How big of a project is it to change all of the queries? You can automate but it is very complicated. The solution is to write a virtual terminal application which will mimick the keystrokes for each query in a library. I have done this using code by:
* = Copyright (c) 2002 by Jeff Yanoviak
* = All rights reserved.
* = Program……. UPDQRYR
* = Description… This is the main program for the UPDQRY command. The program opens a virtual terminal, signs on using the supplied user name and password, starts the WRKQRY display, and loops through the supplied list of queries updating them. If the query update encounters an error, the error text is forwarded to the job log.
go to goggle and type in “Jeff Yanoviak updqry” and you can see what he did. It works great, but it is not for the faint hearted.