Re: how to recreate queries

[Jerry Draper <midrangel@xxxxxxxxxxxxx>]

I can call them up one at a time in WRKQRY and reset the file but there 
are hundreds.

J



On 11/15/2013 1:56 PM, Gary Thompson wrote:
> Jerry,
>
> 1. Way, WAY back one could retrieve query source but
>     I doubt you are on a box that old.
>
> 2. Maybe you could get some relief by converting to QM Query,
>     but I don't think you will actually like that option.
>
>     I do that here with a home-made cmd/clp which is great
>     as quick/dirty way to get sql and, once in a blue moon,
>     I actually want a QM Query and the extra function.
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Draper
> Sent: Friday, November 15, 2013 2:40 PM
> To: Midrange Systems Technical Discussion
> Subject: how to recreate queries
>
> I have a ton of queries created in WRKQRY that work against our ERP system.
>
> We are planning to upgrade the ERP system and the new version has many db changes.
>
> We need to (re)create the queries so they pick up any db changes.
>
> How can this be accomplished en masse?
>
> TIA,
>
> Jerry
>
> --
> Jerome Draper, Trilobyte Software Systems, since 1976 iSeries, Network, and Connectivity Specialists -- iSeries, LAN/WAN/VPN Representing WinTronix, Synapse, Netopia, HiT, and others .....
> (415) 457-3431; www.trilosoft.com
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.