Re: OPNQRYF

[Pete Hall <peteh@xxxxxxxxxx>]

At 16:09 07/15/98 -0400, Loyd Goodbar wrote:
>When using OPNQRYF, CPYFRMQRYF or RUNQRY, is it possible to select
>particular columns for reporting? In other words, I have columns A, B,
>and C in a file. I only want to see columns A and C in my output. Can I
>do that? (I don't have Query/400 available for quick queries...)

Loyd,

You can create a physical file with only the fields that you want in your 
output and specify that as the format in OPNQRYF. CPYFRMQRYF will use it to 
create a new physical file matching the layout of the format file. You can also 
use a query management query (which is part of OS/400, not an additional 
licensed program product).

Create a source member with an SQL statement, something like:

  SELECT FIELDA, FIELDB FROM FILEC ORDER BY FIELDA

Compile it with the CRTQMQRY command and execute it with STRQMQRY. By default 
it will display on the screen, but you can send the output to a physical file 
(it can be created on the fly by STRQMQRY), or to a printer.

Pete


Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---