RE: Changing the library name in a query

["Draper, Dale" <dale.draper@xxxxxxxxxxxx>]

Chuck, these are saved queries in a library used via WRKQRY.

Theresa, you're gonna have to go through some pain.

But, just maybe, an SQL update of these values?


-----Original Message-----
From: Chuck Morehead [mailto:cbmorehead@nokuse.com]
Sent: Thursday, December 06, 2001 5: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.