How do you output data in db2 ?



Example in Oracle:



SQL> SET SERVEROUTPUT ON

SQL> DECLARE

2 p_name VARCHAR2(10):='Oracle';

3 BEGIN

4 dbms_output.put_line(p_name);

5 END;

6 /

Oracle



PL/SQL procedure successfully completed.



Basically, I want to print out value of text when my SQL PL stored procedure
runs...This just for debugging purposes..





Thanks,

Regis







*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************

DB2 & UDB email list listserv db2-l LazyDBA home page