RE: Running queries over multiple environments?

["Nathan Quinones" <Nathan.Quinones@xxxxxxxxxx>]

If you run your queries from CL programs or from MAPICS menus, I would
suggest that you specify all the file names on the RUNQRY command as
follows:

RUNQRY QRY(QUERYLIB/QUERYNAME) 
QRYFILE((*LIBL/FILE1) (*LIBL/FILE2) (*LIBL/FILE3))

This will make the query run using the library list instead of what is
hard coded in the query definition.

Nathan Quinones
Custom Systems Corporation
973-726-0202 x213

-----Original Message-----
From: Lois White [mailto:lwhite@xxxxxxxxxxxxxxxxxx] 
Sent: Monday, November 03, 2003 11:37 AM
To: mapics-l@xxxxxxxxxxxx
Subject: Running queries over multiple environments?

  I was wondering if anyone has a solution to having to change all their
queries that are pointing to a specific environment when a new
environment
is created.  We create multiple environments through out the year for
separate functions and each one is a full environment that has to work
independently.  This means going into several hundred queries and
changing
the file libraries, which becomes a long boring job that is a waste of
time
and man power.  Do I need to change them all to query management queries
to
run over a library list or is there some kind of neat tool or in house
solution out there?  Any suggestions would be greatly appreciated.

 

Lois White

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.