Re: Query to RPG Converter

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

Steve,

As a first step you could run the RTVQMQRY command. This will take a QRYDFN
and generate a source member that contains the SQL statement that is
equivalent to the QRYDFN. The source file is usually named QQMQRYSRC and
needs to have RCDLEN(91)--yes, 91!

Then you can copy that statement into SQLRPG source.

This does nothing, tho', for the layout.

At 09:07 AM 8/16/97 -0500, you wrote:
>A friend of mine is looking for a program that will convert Queries to RPG
>or even RPGSQL.  Has anyone seen one?
>
>Steven Easton 

Cheers

Vernon Hamberg
System Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *