Clever Geek Handbook

How do we make DBMS OUTPUT line in db2 (as you can in oracle)

In oracle, we can print output using dbms_output.put_line (), but DB2 I don't know.

Now I am using "signal" to print some message when debugging.

+1


source to share


2 answers


You can store the row in a permanent debug table or in a declared global temporary table (DGTT). You can also write a simple Java stored procedure that stores a line of text in a file.



When DB2 9.7 is released (sometimes in June 2009), it will automatically ship with the dbms_output function as part of the new DB2 dialect SQL support (Oracle.Aka compatibility).

+1


source


You can do:



select 'message' from sysibm.sysdummy1;
+1


source






More articles:


All Articles