var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 Message /Print facility
I am quite new to DB2 , is there a similar function /package or plain command like oracle's dbms_output_put OR PRINT command to output a Message text within a stored procedure or sql statement?
for eg I would an output message like this:
IF INPUT > OUTPUT THEN
SET 'MESSAGE' = 'This is an output message of the logical operation' ;
DB2 udb Version 8.1
Not directly. But see this article for writing to a file from a DB2 UDF:
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
No actually I dont think thats what im looking for.
How about this idea, capture the message into an output parameter?
Anyone done this?
All I want is a message text displaying the results of a stored procedure.
Search in the manuals for GET DIAGNOSTICS and MESSAGE_TEXT
Visit the new-look IDUG Website
, register to gain access to the excellent content.