Hello All,

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' ;

end if

Thanks

DB2 udb Version 8.1
AIX 5.1

Thanks
mac

Not directly. But see this article for writing to a file from a DB2 UDF:

http://www-106.ibm.com/developerwork...0302izuha.html

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.
thanks
mac

Search in the manuals for GET DIAGNOSTICS and MESSAGE_TEXT

HTH

Sathyaram