RE: Changing the library name in a query

["Luebeck, Theresa" <TLuebeck@xxxxxxxxxxx>]

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:cbmorehead@nokuse.com]
Sent: Thursday, December 06, 2001 7:50 AM
To: midrange-l@midrange.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-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.