RE: Passing Parameters to Query -- format problems

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

Unfortunately, no.  There's an appendix to the QMQRY manual that goes into
great detail on incompatibilities between Query400 and QMQRYs.  You can do
darned near anything you want with the printed output if you learn how to
code QMFORMS.  It's all documented in (at least the US manual) in a language
that bears a deceptive resemblance to English.  Don't look to SEU for any
help.

I pretty much use them for output to a file.

> -----Original Message-----
> From: Peter Dow [mailto:pcdow@yahoo.com]
> Sent: Wednesday, February 16, 2000 5:52 PM
> To: MIDRANGE-L@midrange.com
> Subject: Passing Parameters to Query -- format problems
> 
> 
> I finally had the opportunity to use the method described at
> 
> http://as400service.rochester.ibm.com/s_dir/slkbase.NSF/$searc
> hform?Open&vie
> 
> (search for "Passing Parameters to a Query/400 Query").
> 
> This method works fine as far as the parameters are concerned.
> 
> However, there are drawbacks. QM query manager does a poor 
> job of importing
> the report formatting of the Query/400 query. It loses edit codes for
> numeric fields, column spacing for all fields, standard 
> headers are lost,
> and the report width is not used to automatically override 
> the QPQXPRTF
> printer file - instead it will either leave lots of blank 
> space to the right
> (if the data is smaller than the printer file page width) or 
> create multiple
> spool files with different horizontal sections of the report 
> (if the data is
> larger than the page width).
> 
> To get the QM query to look like the Query/400 output 
> requires more work
> than expected based on this document.
> 
> Am I missing something?
> 
> Peter Dow
> Dow Software Services, Inc.
> 909 425-0194 voice
> 909 425-0196 fax
> 
> 
> 
> 
+---
| 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
+---