Stored procedures debugging.

#1

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?

#2

db2sysc (AT) yahoo (DOT) com wrote:

Quote:

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?

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

#3

db2sysc (AT) yahoo (DOT) com wrote:

Quote:

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?

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Stored procedures debugging.

comp.databases.ibm-db2 comp.databases.ibm-db2

Stored procedures debugging. - 05-02-2005 , 07:25 AM

Re: Stored procedures debugging. - 05-02-2005 , 07:43 AM

Re: Stored procedures debugging. - 05-02-2005 , 07:43 AM