QUERIES

200 pts.
Tags:
AS/400
CLP
RPG
RPGLE
I will be upgrading our software soon. All library names will be changing and we have tons of queries. Is there a way to automatically change the library names in my queries without having to go into each individual query separately?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Since Query/400 should have been discarded more than a decade ago and you're upgrading your software, drop Query/400 now. Don't drag it along until it's entirely out of any support at all. Move to QM queries before it too is obsolete. Had you dumped Query/400 back in the early '90s when you should have, you wouldn't be having the same problem today. Note that even with the Jeff Yanoviak tool you still won't know if you caught everything (which you probably won't) until you run a bad query. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following