Here's a tough one.
We currently have a few hundred user defined queries.
Created with the WRKQRY command.
We are looking at a software upgrade that now puts the production data in a new library.
When a user creates a querey and leaves the library *LIBL, it defaults in the first library it finds the data file in.
This would be great if the *LIBL stayed as it would always grab the current production library.
It does not.
This means our department and the users need to change every querey defined. It's a simple change. Basically we need to change the library the data is found in from "OUR20DATA" to "OUR30DATA".
This is very time consuming as we have done this in the past.
Now with more users and more queries we are looking for a way to automate the data library change process.
Is there a command or function that can be used to develop an application to do this?
Thanks in advance