Re: Viewing the resultant SQL in an RPG program

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.