Search, Replace and Duplicate Utility

This tool is useful to duplicate a string and substitute with specified values. It can be useful to generate a series of SQL statements based on a model statement. By default we use @@@ as substitution variable.

Enter a model statement used for substitutions SELECT * FROM MYLIB@@@/MYCUST WHERE OVER120 <> 0 AND ACTIVE = 'Y' AND CPY = @@@ UNION
Enter Value to search for @@@
Enter a comma delimited list of values that you want to substitute 001,002,003,004,005,006,007,009,010,020,061,062,063,064,065,203,207,208,221,281,291

Substitute & Duplicate!