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
Fuangwith S.
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
Fred Sobotka
source
to share
You can do:
select 'message' from sysibm.sysdummy1;
+1
Rashmi Pandit
source
to share