Re: Query conversion

[Pete Hall <pbhall@xxxxxxxxxx>]

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
+---