Re: OPNQRYF

[Ravi <ravi@xxxxxxxxxxxxx>]

Loyd,

Have you considered using QM query? You just need to enter the SQL
statements in a member with type TXT. (ex) select fld1,fld2 from fileA.
Then CRTQMQRY and then STRQMQRY.

Hope this helps.

Ravi
Systems Group


Goodbar, Loyd (AFS-Water Valley) 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 Goodbar
> Senior Programmer/Analyst
> Air/Fluid Systems
> Borg-Warner Automotive
> Water Valley MS
> 
> +---
> | 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
> +---
+---
| 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
+---