MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2012

Re: From QRYDFN to SQL



fixed

Actually, on RUNQRY, you can specify *LIBL as the file library:

RUNQRY QRY(QUERY1) QRYFILE((*LIBL/FILE1) (*LIBL/FILE2))


On 9/16/2012 9:15 AM, rob@xxxxxxxxx wrote:
RUNQRY allows some override, providing you remember to run that. However
two things.
1 - You have to remember to provide that. Who always does? And, that
would be in your program library, not your data library. So, unless you
do like Infor and retrieve your data library from some data area and use
that variable on your runqry all bets are off.
2 - If you have more than one library you're using (PRODa, PRODb ) and
want to go to (TESTa, TESTb) can you do that?


Rob Berendt






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact