Re: Convert QU1 queries to SQL

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

RTVQMQRY does the job but sometimes has problems. When you run it, you 
get warnings in your job log about the issues. You can also run ANZQMQRY 
to get the message first.

All the QU1 join types are converted in a type 1. You have to go into 
the source that results from RTVQMQRY and change the JOIN 
specifications. The source file you want has to be RCDLEN(91) - this has 
to do with some cross=platform thing.

The issues are described in the Query Management Programming manual - 
it's available through InfoCenter under Database and manuals. At v6.1 
its link is

http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/topic/rzatc/sc415703.pdf

Have fun!
Vern

DeLong, Eric wrote:
> Well, I think RTVQMQRY does it, but not very well.  As I recall,
> converting a QU1 query to QMQry has problems with file joins of certain
> types.
>
> Alternative might be T.O.A.D, which is a client tool that supports Query
> definitions.  It probably suffers the same conversion issues.
> http://www.innovativesys.net/?page_id=8
>
> -Eric
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Graap, Kenneth
> Sent: Friday, March 26, 2010 4:29 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: Convert QU1 queries to SQL
>
> Does anyone know how to automatically convert a QU1 defined query into
> an SQL script?
>
> P
> Please consider the environment before printing this email
>
> Kenneth
> Kenneth E. Graap
> Systems Administrator
> NW Natural
> keg@xxxxxxxxxxxxx<mailto:keg@xxxxxxxxxxxxx>
> http://www.linkedin.com/in/kennethgraap
> 503-226-4211 x5537
>
>