Hi All, Would anybody know how to or have a tool to change library names in qry without going into each qry ???? Thanks in advance, Nico Vrancken
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Change the lib name in QRY
Collapse
X
-
Change the lib name in QRY
If you're talking about changing the library name from which the QUERY/400 query will run, the answer AFAIK is no. If you're talking about changing the library name of the files that the QUERY/400 query uses, the answer is yes. In the RUNQRY (or is it QRYRUN) command, there is a parameter that allows you to substitute the name of the input file. If you are using a CL program, this can be a variable. If several queries are used within the CL, you can globally change the input data, by simply changing the variable. Dave
Comment