Is there a way out to Print on the console during the execution of
Stored Procedures.

vj wrote:
> Is there a way out to Print on the console during the execution of
> Stored Procedures.
>
During the execution: No, at least no built-in one.
For debugging (I presuem that's what you want to do)
you can use a temp table.. There was a thread just yesterday about logging.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Keep in mind any stored procedure is running inside a DB2 server
process, which in essence means the procedure code is running inside a
server daemon process -- in other words, background processes. Daemon's
typically have their STDOUT & STDERR outputs disabled (to use a unix
term, piped to /dev/null) -- as:

1) For a multi-user system, which display gets the output?
2) Who's to say there is actually a console to display the output on?

Your best bet to see any output from a procedure is to open a file
inside that procedure, and direct any output of the procedure to that file.

vj wrote:

> Is there a way out to Print on the console during the execution of
> Stored Procedures.
>