Re: Query conversion

[Wayne Capwell <wayne@xxxxxxxxxxxxxx>]

Thanks to all for your help.  I think I can get what I need.

Buck Calabro wrote:
> 
> Create a QMQRY source file, then use the RTVQMQRY command like so:
> RTVQMQRY QMQRY(QRY400OBJ) SRCFILE(QQMQRYSRC) ALWQRYDFN(*YES)
> 
> Be aware that some QRY/400 queries won't translate into SQL.  For more
> details on the process, see the DB2 for AS/400 Query Management Programming
> guide.  There's a section on converting QRY/400 to QMQRY.
> 
> Buck Calabro
> Aptis; Albany, NY
> mailto:Buck.Calabro@aptissoftware.com
> 
> > -----Original Message-----
> > From: Wayne Capwell
> > Sent: Friday, September 03, 1999 4:06 PM
> > To:   midrange
> > Subject:      Query conversion
> >
> > I have a bunch of AS/400 queries that I would like to change into SQL.
> > Is there a way of taking a saved query definition and translating it
> > into SQL?  Many of these queries have multiple joins so the translation
> > would save a lot of time trying to figure it out.  SQL syntax is not my
> > strong suite.
> >
> +---
> | 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
> +---

-- 
______________________________________
Wayne W. Capwell
Red Oak Technologies, Inc.
11301 Carmel Commons Blvd., Suite 114   
Charlotte, NC  28226
704-945-1067

Manufacturing...Production...Solutions
     http://www.redoaktech.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
+---