DB2 : print statement in stored procedure

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by db2_udb 0n 02 January 2009

I have written a stored procedure in db2 and want to print the value of a
variable at different stages of execution.

one way would be to debug the SP, but as the SP is executing for quite some time I wanted to put display statement for this variable so that I caand can see the execution of SP.

Could you any one please tell me the syntax for the same.?

Learn more about DB2 databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting