RE: QRYDFN

Thanks guys for all the info and help.

Yes Jerry - I have the code written by Jeff Yanoviak but have yet to test
it - will post the findings though :)

Kind regards,

Prevesh Kuni
RPG Developer
Business Systems Atlas Copco ASAP Southern Africa
P.O. Box 14110
Witfield
1467
South Africa

Phone: +27 (0)11 821 9000 - Phone dir.: +27 (0)11 821 9245 - Mobile: +27
(0)83 679 8197 - Fax: +27 (0)11 252 9393
E-mail: prevesh.kuni@xxxxxxxxxxxxxxxxx
Visit Atlas Copco at: www.atlascopco.com
We are committed to your superior productivity through interaction and
innovation




Jerry Adams <Jerry@xxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
2009/02/24 23:52
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: QRYDFN






The QRYFILE option, I think, provides this same functionality, but I've
never used it for such. I have used the OVRPRTF for QPQUPRFIL so that a
query can be printed at a selected printer.

For files, though, whenever I change a file definition, I always just bite
the bullet and re-compile it. There's a neat utility (DSPQRYF) that I
found at System i Network that can be run against all of the queries in a
library (or selected queries/sets) that puts all of the file information
in an outfile that can then be, you guessed it, queried. There was a
change to some part of the *QRYDFN object from V5R3 to V5R4 that
necessitated a change to the utility. Which is one of the gotchas with
using some utilities like this; I don't know if the author (Jeff Yanoviak)
posted the change or not (doesn't look like it from the article
description).

There is another one (DSPQRYREF) at MCPressOnline.

I don't see an API that would provide information about a *QRYDFN object,
but I've missed more than one so there might be.

Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Arnold (MFS)
Sent: Tuesday, February 24, 2009 3:00 PM
To: Midrange Systems Technical Discussion
Subject: RE: QRYDFN

If all you want to do is use the same file structure in a different
library, you could use a CL to override your file with an OVRDBF but you
would need to know the file being used by every query you wanted to
override.
The CL would be:

PGM
OVRDBF FILE(File referenced in query) TOFILE(new library/new
filename)
RUNQRY QRY(query name)
ENDPGM



John Arnold
(301) 354-2939

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Prevesh.Kuni@xxxxxxxxxxxxxxxxx
Sent: Tuesday, February 24, 2009 8:04 AM
To: midrange-l@xxxxxxxxxxxx
Subject: QRYDFN

Hi Guys,

Is it possible to programmatically change the file selection library in
a
*QRYDFN?

We have hundreds of queries where a file library needs to change....

I have done passing parms to a QMQRY but these are existing *QRYDFN

Any help would be greatly appreciated - thanks

Kind regards,

Prevesh Kuni
RPG Developer
Business Systems Atlas Copco ASAP Southern Africa
P.O. Box 14110
Witfield
1467
South Africa

Phone: +27 (0)11 821 9000 - Phone dir.: +27 (0)11 821 9245 - Mobile: +27

(0)83 679 8197 - Fax: +27 (0)11 252 9393
E-mail: prevesh.kuni@xxxxxxxxxxxxxxxxx
Visit Atlas Copco at: www.atlascopco.com
We are committed to your superior productivity through interaction and
innovation