Announcement

Announcement Module
Collapse
No announcement yet.

Change the lib name in QRY

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Change the lib name in QRY

    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

  • #2
    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

    Working...
    X