RE: how to debug a stored SQL procedure

Yes, it's possible. What you have to do depends upon your environment 
(basically, if you're running it on a remote system or not).

If you're running it locally, you should be able to just put the program your 
stored procedure definition refers to in debug and run your program. If that 
doesn't work, you'll need to see if the procedure is running in a separate job 
(I think it'll be a QSQSRVR job). If that's the case, you'll have to start a 
service job on the job that actually runs it.

If you're running remotely, you'll need to start a service job on the remote 
system and then put the program in debug. The job log on the local system (this 
is the one that made the call) will have the job name that you need to start 
the service job on the remote system. The message that you see in the job logs 
depends upon how the communications are set up (ANYNET vs.  TCP/IP) but are 
easy enough to find in the job log. Once you find the message in the job log on 
the local system, displaying the additional message text will give you this 
information.

Matt

-----Original Message-----
From: heba refaie [mailto:heba_refaie@xxxxxxxxxxx]
Sent: Monday, July 07, 2003 11:21 AM
To: RPG400-L@xxxxxxxxxxxx
Subject: how to debug a stored SQL procedure


Hello Every One

If I have CLI PRPGLE and I am at the stmt where

C                   EVAL      SQL_RC = SQLExecDirect (
C                                         hstmt :
C                                         %addr(SQLStmt) :
C                                         SQL_NTS
C                                      )

SQLStmt contains a call to a stored procedure " Call Qgpl.myProc"

is it possible to debug the SQL code inside myproc with the normal ILE green 
screen
Debugger...how can it be done?

Thanks a lot for you help
Heba