Re: How do you output the results of WRKQRY cmd to a outfile? -- MIDRANGE-L

DSPOBJD on a *QRYDFN does not tell you anything about files used. Besides, it is possible to name different files when you RUNQRY, so the definition is only a hint as to what is really being used. You can also specify different output types in RUNQRY, so, again, the *QRYDFN is more of a template than the final word.

DMPOBJ of a *QRYDFN will give you lots of info in some format - there are some who have figured it all out.

Vern

Jernigan, John (Jay) wrote:

I should have tried that. I have done that with different object types did not think to look and see if I could do it with a qrydfn. Thanks for the solution. Another question is there a way to identify what files are being used in a set of queries in a particular library?

Alamance Regional Medical Center
Jay Jernigan
jjerngian@xxxxxxxx
________________________________________
From: midrange-l-bounces@xxxxxxxxxxxx [midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vinay Gavankar [vinaygav@xxxxxxxxx]
Sent: Monday, March 22, 2010 7:29 PM
To: Midrange Systems Technical Discussion
Subject: Re: How do you output the results of WRKQRY cmd to a outfile?

You can do a DSPOBJD with OBJTYPE of *QRYDFN and get the output to an
OUTFILE.

Vinay

On Mon, Mar 22, 2010 at 6:18 PM, Jernigan, John (Jay) <jernjohn@xxxxxxxx>wrote:

Sorry I meant to say description field. And the question was vague. When
you do a wrkqry it shows the following screen.
Work with Queries

Type choices, press Enter.

Option . . . . . . 1=Create, 2=Change, 3=Copy, 4=Delete
5=Display, 6=Print definition
8=Run in batch, 9=Run
Query . . . . . . . Name, F4 for list
Library . . . . . hs#libr Name, *LIBL, F4 for list

when you do a f4 list on the query field for the library selected you get
the following screen. My question is how can i output this data to an out
file to be able to do a search on the descrition field below.

Work with Queries

Library . . . . . . . . HS#LIBR Name, *LIBL, F4 for list
Subset . . . . . . . . Name, generic*
Position to . . . . . . Starting characters

Type options (and Query), press Enter.
1=Create 2=Change 3=Copy 4=Delete 5=Display 6=Print
8=Run in batch 9=Run
Opt Query Text
Changed

ACCLINIC Clinic B accts
06/09/09
ACCTRME#2 daily RME registration report
01/04/10
ACCTRMEPRT daily RME registration report
02/16/10
ACCTUNITG report unmatched phpacct V.S. Phpunit by gua
08/07/08
ACCTUNITP LOCATE ACCTS WITH MISSING UNIT RECORD APREF
08/07/08
ACMH_ACCTS Listing of O/S ACMH Accts in AR
08/07/08
ACSPECTRA Spectra accts for Angie Carver
03/06/09
ACTEMPFTPT ACTUAL EMPLOYEES-FT AND PT
08/07/08
ACTNEWEMP
08/07/08

More...
F3=Exit F4=Prompt F5=Refresh F11=Display names
only
F12=Cancel F19=Next group

Alamance Regional Medical Center
Jay Jernigan
jjerngian@xxxxxxxx
________________________________________
From: midrange-l-bounces@xxxxxxxxxxxx [midrange-l-bounces@xxxxxxxxxxxx] On
Behalf Of CRPence [CRPbottle@xxxxxxxxx]
Sent: Monday, March 22, 2010 6:22 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: How do you output the results of WRKQRY cmd to a outfile?

Please attempt to be more explicit on _what about WRKQRY_ is
desired to be made available in the output file. Perhaps just issue
the WRKQRY command at a command line, then describe:

- each action performed

- describe what, from each of those actions performed, is the
"result" of interest [i.e. what is desired] to have appear in an
output file

If the alluded "description file" is instead specific to any one
particular query definition object [that had been created
previously; i.e. an existing *QRYDFN], then perhaps something like
RTVQMQRY, RTVQMFORM, or 6=Print Query [option within WRKQRY] issued
for that specific *QRYDFN object is what is of interest?

Regards, Chuck

Jernigan, John (Jay) wrote:

I would like to output the results of the WRKQRY cmd to a outfile
so I can do a search on the description file. Or what is the file
name on the system that contains this information?

--
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.

______________________________________________________________________
Notice: The information contained in this message (Including attachments)
is covered by the Electronic Communications Privacy Act, 18 U.S.C.
2510-2521, is confidential and may be legally protected from disclosure. If
you are not the intended recipient, or an employee or agent responsible for
delivering this message to the intended recipient, you are hereby notified
that any retention, dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify the Sender immediately by replying to
the message and deleting it from your computer.
______________________________________________________________________
--
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.

--
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.

______________________________________________________________________
Notice: The information contained in this message (Including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally protected from disclosure. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any retention, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the Sender immediately by replying to the message and deleting it from your computer. ______________________________________________________________________