How do we do a DBMS OUTPUT line in db2 (like you can in oracle)

Question

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

Now, I use 'signal' for print some message when I debug.

Answer 1

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

When DB2 9.7 is released (sometime in June 2009) it will automatically come with the dbms_output feature as part of DB2's new "SQL dialect" support (a.k.a Oracle compatibility).

Answer 2

You can do:

select 'message' from sysibm.sysdummy1;