Change the lib name in QRY

[Guest.Visitor]

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

[David Abramowitz]

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