RE: Converting a Query to RPG

["Jerry Myrick" <myrickjr@xxxxxxxxxxxxx>]

Just curious as to why you want to convert the Query to RPG? Is there
something your trying accomplish that you believe can't or are for sure
can't be done in Query? 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Joel Fritz
Sent: Friday, May 16, 2003 6:23 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Converting a Query to RPG

There are also some things relating to summaries to files that don't
translate.  There's a chapter in the Query Management Programming manual
that lists the differences.  

I think the RPG code generator that uses queries as input is a utility
yet
to be.

> -----Original Message-----
> From: Steve Landess [mailto:steve_landess@xxxxxxxxxxx]
> Sent: Friday, May 16, 2003 4:09 PM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: Converting a Query to RPG
> 
> 
> > Rob wrote:
> 
> > RTVQMQRY.
> 
> > Amitava wrote:
> > Hi. Thanks. But actually I did not want to do it in those 
> ways (WRKQRY,
> then
> > print etc). I mean, I thought all the information should be 
> some where in
> > the system (some file ?). A generic program will read that 
> and generate
> > the RPG source for the query. It will be a generic program, 
> that will
> > convert any query to a RPG.
> >
> > I tried CRTQMQRY. But that did not give all information and 
> whatever it
> > gave is not in a specific format. Or did I do some thing wrong?
> 
> Folks -
> 
> I would strongly advise against using RTVQMQRY to retrieve 
> the query source
> for a query unless you first visually inspect the  query 
> using option 2 or 5
> within WRKQRY to determine what it does.
> 
> To see why I make this statement, create a query that joins 
> two files using
> option 3 (Unmatched records with primary file).  Then 
> retrieve the source
/*****************************  Big Snip ****************/
NOTICE:
All e-mail sent to or from this e-mail address will be received or
otherwise
recorded 
by The Sharper Image corporate e-mail system and is subject to archival,

monitoring, review by and/or disclosure to Sharper Image security and
other 
management. This message is intended only for the use of the addressee
and
may 
contain information that is privileged and confidential. The contents of
this message 
may contain personal views which are not the views of The Sharper Image.
If
you are 
not the intended recipient, dissemination of this communication is
prohibited.

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.