Displaying variables from procedures - Urgent!

[s***@yahoo.com]

How do I display variables from stored procedures?

In oracle they can be displayed using DBMS_OUTPUT.PUT_LINE(...)
Is there something similar in DB2?

[Knut Stolze]

Post by s***@yahoo.com
How do I display variables from stored procedures?
In oracle they can be displayed using DBMS_OUTPUT.PUT_LINE(...)
Is there something similar in DB2?

You can use the SQL debugger that is available in the application
development center, or you do the same as on oracle and invoke a function
that writes the data to a file. The latter is described here, for example:
http://tinyurl.com/agvaw