Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I output messages to the screen from within a procedure?

Status
Not open for further replies.

DB2Novice

Programmer
Mar 8, 2003
2
CA
Hi there,

I am a novice at using DB2 but have worked with Oracle before. Currently the DB2 is residing on a Linux Server and I am developing from a Win 2K machine.

I do not know if there is an equivalent of the Oracle DBMS_OUTPUT.PUT_LINE command in DB2 to display messages to screen from within a stored procedure while running? I want to be able to display messages to screen on the db2 console or in the messages section at the bottom of the Procedure Builder to see the values of my variables while processing.

Thanks for all your help,
Kyri
 
I am also a newbie and would like to know if you found an answer to this question.

Thanks,

Tim
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top