Re: WRKQRY output files: how to determine w/o using WRKQRY

You can use DMPOBJ on the queries and scan for the file name in the QPSRVDMP
spooled file produced by the command.

DMPOBJ doesn't allow generic names, but this could be automated with a CL
program, and you could use CPYSPLF to copy the spooled files to a database
file where you could then use an RPG program to scan the data for the file
name.

Steve

----- Original Message ----- 
From: "G Armour" <>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, June 10, 2004 4:06 PM
Subject: WRKQRY output files: how to determine w/o using WRKQRY


> I've got a data file with externally described fields that I cannot
> determine where or how it was created.  DSPOBJD *SERVICE shows blanks for
> the source information.  I already did a DSPPGMREF *ALL/*ALL to an
> outfile, and there's nothing showing that creates the file.
>
> Since this file has 'QRY' at the end of its name, I'm guessing that it was
> created by a query (duh), but I've not found any queries that come close
> to the name of the file.  There are hundreds of queries on our system.
>
> Tried RTVQMQRY on all of these queries and scanned for the file name, but
> information on the query output is NOT included in the QMQRY source.  (I
> tested this with a query I knew outputs to a data file.)
>
> I was hoping to find some API or other utility that would pull this
> information out of the *QRYDFN objects.  Anybody know?
>
> TIA, GA
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Friends.  Fun.  Try the all-new Yahoo! Messenger.
> http://messenger.yahoo.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.
>
>