× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.