display statements in a stored proc..is it possible????

Lkmi · New User Joined: 04 Mar 2005 Posts: 53 Location: Newyork

Is it possible to have display statements in a stored proc ????

Iam trying to test a DB2 stored proc using IBM-DB2 development center.

is teher any way by which i can see the o/p of my displays????????

DavidatK · Posted: Fri Jul 28, 2006 5:38 am

Absolutely, it will show up in your SYSOUT. We do this all the time for exception/error conditions

Dave

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 269 Location: India

Hi David,

Will it show the messages in SYSOUT of the JCL submitted by user?

Suppose, I have an application program using a DB2 stored procedure. Will the display statements in the stored procedures will go to the SYSOUT of the JCL I submit to run that app program?

I believe it should go to some DB2 logs. I am not really sure.

Thanks,
Parikshit.