467,189 Members | 1,343 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

print value during execution stored procedure

Hi,

I am a bit new to db2, and I am unable to find a proper command syntax where
I can print values during execution in a stored procedure

Pls help.

regards,
guillaume
Aug 17 '07 #1
  • viewed: 20225
Share:
2 Replies
GUILLAUME LECOMTE wrote:
I am a bit new to db2, and I am unable to find a proper command syntax where
I can print values during execution in a stored procedure
DB2 does not have a PRINT statement.
If you want to do debugging use the Developer Workbench.
If you want to print a report insert your report data into a temporary
table (DECLARE GLOBAL TEMPORRAY TABLE). Declare a cursor WITH RETURN TO
CLIENT that dumps the temp table and OPEN the cursor before you finish
the stored procedure.
The command line processor will receive the result set (very much like a
query without a cursor in TSQL) and print it out AFTER the procedure is
finished.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Aug 17 '07 #2

Hi Serge,
Thank you very much for the help!... I'll use Developer Workbench (it's more
that i'm searching for)
(sorry for english)
guillaume

"Serge Rielau" <sr*****@ca.ibm.coma crit dans le message de news:
5i*************@mid.individual.net...
GUILLAUME LECOMTE wrote:
>I am a bit new to db2, and I am unable to find a proper command syntax
where I can print values during execution in a stored procedure
DB2 does not have a PRINT statement.
If you want to do debugging use the Developer Workbench.
If you want to print a report insert your report data into a temporary
table (DECLARE GLOBAL TEMPORRAY TABLE). Declare a cursor WITH RETURN TO
CLIENT that dumps the temp table and OPEN the cursor before you finish the
stored procedure.
The command line processor will receive the result set (very much like a
query without a cursor in TSQL) and print it out AFTER the procedure is
finished.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Aug 17 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Wim van Rosmalen | last post: by
16 posts views Thread by Wade Ward | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.