Re: Viewing the resultant SQL in an RPG program

[Pete Helgren <Pete@xxxxxxxxxx>]

Yep, that is what I see.  It sure would be a nice feature to see the 
actual, resolved, SQL though. 

I'll do some trial and error testing of the statement using different 
variables and commenting portions of the statement and see if I can 
figure out why the SQL is not returning records like I expect.  The 
*LOVAL/*HIVAL technique is a good one, I just need to know what to 
submit in the SQL for *LOVAL and *HIVAL when the field is a 10 character 
numeric.

Pete


Wilt, Charles wrote:
> Pete,
>
> Yes, that's correct.
>
> But you won't be able to cut & paste between Ops-Nav and STRSQL because as vern pointed out, the
> statements being run will be using parameter markers.
>
> Charles
>  
>
>   
> > -----Original Message-----
> > From: rpg400-l-bounces@xxxxxxxxxxxx 
> > [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
> > Sent: Thursday, September 06, 2007 9:54 AM
> > To: RPG programming on the AS400 / iSeries
> > Subject: Re: Viewing the resultant SQL in an RPG program
> >
> > Charles,
> >
> > I developed an early aversion to iSeries navigator (and 
> > iSeries Access in general) that I haven't completely overcome 
> > yet so I am fairly unfamiliar with how to use the SQL 
> > monitoring.  Would the navigation be "Databases"-->[System 
> > Name]-->SQL Performance Monitors ?
> >
> > Pete
> >
> >
> > Wilt, Charles wrote:
> >     
> > > Pete,
> > >
> > > Joe's answer usually works for me also. 
> > >
> > > You can however do exactly what you are asking by using the 
> > >       
> > SQL monitoring functions in Ops-Nav.
> >     
> > > If the job only runs one statement, you can try right 
> > >       
> > clicking on the 
> >     
> > > job and selecting 'Details'-->'Last SQL Statement'.
> > >
> > > If there's more than one statement, or the above doesn't work, try 
> > > starting a detailed SQL performance monitor for the job.
> > >
> > > HTH,
> > > Charles
> > >
> > >
> > >   
> > >       
> > > > -----Original Message-----
> > > > From: rpg400-l-bounces+wiltc=cintas.com@xxxxxxxxxxxx
> > > > [mailto:rpg400-l-bounces+wiltc=cintas.com@xxxxxxxxxxxx] On 
> > > >         
> > Behalf Of 
> >     
> > > > Pete Helgren
> > > > Sent: Thursday, September 06, 2007 9:13 AM
> > > > To: RPG programming on the AS400 / iSeries
> > > > Subject: Viewing the resultant SQL in an RPG program
> > > >
> > > > How are folks debugging SQL statements that have host 
> > > >         
> > variables that 
> >     
> > > > are resolved at runtime?  Is there a way to debug a RPG 
> > > >         
> > program with 
> >     
> > > > embedded SQL so you can see the "resolved" statement as it 
> > > >         
> > is passed 
> >     
> > > > to DB2/400?  I have an RPG program with embedded SQL that is 
> > > > returning no rows but when I run a statement that should 
> > > >         
> > be similar 
> >     
> > > > (the "should be"
> > > > is the catch!) in interactive SQL I do get rows returned.
> > > >
> > > > I'd like to "see" what DB2/400 sees when the SQL statement is 
> > > > processed.  Any way to do this ?
> > > >
> > > > Pete Helgren
> > > >
> > > > --
> > > > 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.
> > > >
> > > >
> > > >
> > > >     
> > > >         
> > > This e-mail transmission contains information that is 
> > >       
> > intended to be confidential and privileged.  If you receive 
> > this e-mail and you are not a named addressee you are hereby 
> > notified that you are not authorized to read, print, retain, 
> > copy or disseminate this communication without the consent of 
> > the sender and that doing so is prohibited and may be 
> > unlawful.  Please reply to the message immediately by 
> > informing the sender that the message was misdirected.  After 
> > replying, please delete and otherwise erase it and any 
> > attachments from your computer system.  Your assistance in 
> > correcting this error is appreciated.
> >     
> > >   
> > >       
> > --
> > 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.
> >
> >
> >
> >     
>
> This e-mail transmission contains information that is intended to be confidential and privileged.  If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful.  Please reply to the message immediately by informing the sender that the message was misdirected.  After replying, please delete and otherwise erase it and any attachments from your computer system.  Your assistance in correcting this error is appreciated.
>
>