SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 01:04 PM
| |||
| |||
 Re: print value during execution stored procedure 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      |
|
02-27-2008, 01:04 PM
| ||||
| ||||
| Re: print value during execution stored procedure 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" <srielau@ca.ibm.com> a écrit dans le message de news: 5ilfarF3pvj86U1@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 |
Linear Mode
