Does db2 have the equivalent of a print statement like SQL server? I
wanted to debug a stored procedure I wrote and wanted to output some of
the values. I couldn't find it in documentation...The only thing that
looked close was signal statement.

no_spam_for_gman wrote:

Does db2 have the equivalent of a print statement like SQL server? I
wanted to debug a stored procedure I wrote and wanted to output some of
the values. I couldn't find it in documentation...The only thing that
looked close was signal statement.
>

No. But you can use Development Center (or Developer Workbench) and
actually debug the stored procedure, which is light years ahead of
using print statements to try and debug.

Ian wrote:

no_spam_for_gman wrote:

>
No. But you can use Development Center (or Developer Workbench) and
actually debug the stored procedure, which is light years ahead of
using print statements to try and debug.
>

For reporting (or if you just are in love with print statements you can
use a DECLARE GLOBAL TEMPORARY TABLE ... NOT LOGGED .. ON ROLLBACK
PRESERVE ROWS
and dump your stuff into that.
Then at the end of your stored proc simply open a CURSOR WITH RETURN TO
CLIENT on the temp table. command line will display it.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html

Thank all for prompt response.