Re: Massive Changes in Query Definitions

I'm not sure if someone has offered this solution yet but here goes:

Yes, you may find a great way to modify the query definition but you
shouldn't be using the hardcoded library in the query definition in the
first place. You would not allow a programmer to hard code a library in a
CLP would you?

You should create a shell program (CLP?) or if these are menu driven, have
the query command in the menu override the files in the RUNQRY command. ie.
RUNQRY QRY(*LIBL/QUERYNAM)   QRYFILE((*LIBL/FILEA))  .
Now these files can be moved when every you need to move them.

I am sure that you run your queries in a development environment (DEVDTA), a
test environment (TSTDTA) and your production environment (PRDDTA). This
will help you in your change management methodology.

Dan Wiesner

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.