output value of variable

[rdharmar]

I am trying to debug some dynamic sql in a stored procedure and I need to output the contents of the string variable. Thanks for your help in advance.

 

[LarryKDB2]

Hi "RDharmar",
I think you should add another "output" parameter to the call list for the s-p and place the string you are curious about into that s-p parameter variable. When you return from the CALL statement, examine that parameter.

Larry Kintisch

IBM Contractor Instructor for DB2, SQl, QMF, Data modeling; [DB2 for z/OS]

 

[rdharmar]

My front end tool is Crystal reports and it would be difficult to examine the output parameter value.

I was able to convince the DBA to create a table ( with one big text field) for debugging. I am now use this table to insert and read the dymanic content.

Thanks.