|
QMQRY does have *OUTFILE support. Just create your QMQRY source member as you normally would and then, using a CL statement like the following, execute the STRQMQRY statement. Works like a champ. The SQL SELECT operation allows you to select records and even to do complex joining. STRQMQRY QMQRY(&SQLExeLibr/&SQL_Name) OUTPUT(&Output) + OUTFILE(&OutFileLib/&OutFileNam) + OUTMBR(&OutFileMbr &MbrOpt) QMQRY also supports passing variables to the query. In the query source, the variable is defined with a colon ":" before the name of the variable (:VARNAME): STRQMQRY QMQRY(&SQLExeLibr/&SQL_Name) SETVAR((VARNAME 'ABC')) Hope this helps, Bill William K. Reger Senior Project Manager Levitz Furniture Corporation Phone: (561) 994-5114 E-mail: breger@levitz.com <mailto:breger@levitz.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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.