I am executing a stored procedure called sp1 (it does delete and update rows ) using DB2 command prompt as :
db2 call sp1
then i can see the message SQL20511N There is not enough available space in the DBMS_OUTPUT message buffer.
But the query was continued and completed successfull and all the outputs (which item deleted and updated) are listed on the screen.
question 1 - how can I resolve the DBMS_OUTPUT buffer issue
question 2 - how can I output the messages into the file rather than on screen.
Please advise me.