RE: Viewing the resultant SQL in an RPG program

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.