RE: Query conversion

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

The documentation for QMFORMs is among the worst ever written.  If you need
to modify one, be prepared to set a spell.  You can do some things in the
header and footer that you can't do with Query400.  Also the default width
for the QMQRY print file is 80 columns.  If you need wider printed output,
you'll need to override the print file.  

> -----Original Message-----
> From: Pete Hall [mailto:pbhall@execpc.com]
> Sent: Tuesday, September 07, 1999 4:03 PM
> To: MIDRANGE-L@midrange.com
> Subject: Re: Query conversion
> 
> 
> At 11:55 09/07/1999 , Dan Bale wrote:
> 
> 
> >Wayne,
> >
> >Please be aware that not everything in an AS/400 query 
> carries over into SQL,
> >most notably the query report layout.
> 
> You can use the RTVQMFRM command to retrieve the output 
> format from the 
> query, CRTQMFRM to create a form that can be referenced by 
> the STRQMQRY 
> command. I've used this a few times and it has reproduced the 
> Query output.
> 
> Pete Hall
> pbhall@execpc.com
> http://www.execpc.com/~pbhall
> +---
> | 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
+---