All:

I want to debug stored procedures in V8.2 and specifically see the
values of my dynamic constructs.

set v_sql ='SELECT COUNT(*) FROM DB2ADMIN. ' || v_table_name;

How do I see value of v_sql during run time?


I tried using SQL DEBUGGER, but was not succcessful. Any pointers?

db2sysc@yahoo.com wrote:
[color=blue]
> All:
>
> I want to debug stored procedures in V8.2 and specifically see the
> values of my dynamic constructs.
>
> set v_sql ='SELECT COUNT(*) FROM DB2ADMIN. ' || v_table_name;
>
> How do I see value of v_sql during run time?
>
>
> I tried using SQL DEBUGGER, but was not succcessful. Any pointers?[/color]

An idea would be to use the technique described here:
http://www-128.ibm.com/developerwork...0302izuha.html

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

db2sysc@yahoo.com wrote:[color=blue]
> All:
>
> I want to debug stored procedures in V8.2 and specifically see the
> values of my dynamic constructs.
>
> set v_sql ='SELECT COUNT(*) FROM DB2ADMIN. ' || v_table_name;
>
> How do I see value of v_sql during run time?
>
>
> I tried using SQL DEBUGGER, but was not succcessful. Any pointers?
>[/color]
I find teh most convenient way to do debugging to have a declared global
temporary table with NOT LOGGED ON ROLLABCK PRESERVE ROWS ON COMMIT
PRESERVE ROWS.
Then I insert debugging information into it and query teh temp at leisure.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab