By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

Stored procedures debugging.

P: n/a
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?

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
db*****@yahoo.com wrote:
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
Nov 12 '05 #2

P: n/a
db*****@yahoo.com wrote:
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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.