Chuck, Yes, you are correct, there is a parameter on the RUNQRY for specifying the library name. I was wondering if there was a way to permanently alter the query to reflect the new library name. And, of course, I'd like to do this in a batch process not manually. Several of my users use WRKQRY and run queries interactively. Unfortunately for me, someone else taught them this and you know how hard it is to take away anything from a user. I'm slowly moving things into place since I started here 3 months ago, but for now I'm looking to make this JDE migration as seamless as possible. Any help is appreciated. Theresa -----Original Message----- From: Chuck Morehead [mailto:firstname.lastname@example.org] Sent: Thursday, December 06, 2001 7:50 AM To: email@example.com Subject: Re: Changing the library name in a query Theresa, Isn't this a parameter in the RUNQRY command? I.e. you can specify the files (including libraries) that the query is to use. Chuck ----- Original Message ----- From: "Luebeck, Theresa" <TLuebeck@Fiskars.com> To: <MIDRANGE-L@midrange.com> Sent: Thursday, December 06, 2001 7:11 AM Subject: Changing the library name in a query > This message is in MIME format. Since your mail reader does not > understand this format, some or all of this message may not be > legible. > -- > [ Picked text/plain from multipart/alternative ] > Does anyone have any suggestions on changing the library name in the file > specifications in a query without having to pull up the query and manually > selecting the file specs? We're migrating from JDE OneWorld on V4R5, old > 720 to OneWorld Xe on V5R1, new 830. I have many queries that must be > updated to reflect the new library names and I'm looking to automate > everything I possibly can. Thanks in advance for your help. > > Theresa Luebeck > AS/400 Systems Manager > Fiskars Consumer Products, Inc. > 608-294-4537 > > _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l or email: MIDRANGE-Lfirstname.lastname@example.org Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.