RE: how to debug a stored SQL procedure

["Carlos Kozuszko" <tidesarrollo@xxxxxxxxxxxxxxxxxxxxxx>]

In Redbook "Stored procedures and Triggers" you'll find detailed information
on how to debug a stored produre.

Carlos K.


> -----Mensaje original-----
> De: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]En nombre de heba refaie
> Enviado el: lunes, 07 de julio de 2003 17:21
> Para: RPG400-L@xxxxxxxxxxxx
> Asunto: 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
>
> _________________________________________________________________
> Help STOP SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> _______________________________________________
> 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.