DB2 10.5 for Linux, UNIX, and Windows

DISABLE procedure - Disable the message buffer

The DISABLE procedure disables the message buffer.

After this procedure runs, any messages that are in the message buffer are discarded. Calls to the PUT, PUT_LINE, or NEW_LINE procedures are ignored, and no error is returned to the sender.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_OUTPUT.DISABLE-----------------------------------------><

Authorization

EXECUTE privilege on the DBMS_OUTPUT module.

Example

The following example disables the message buffer for the current session:

CALL DBMS_OUTPUT.DISABLE@

Usage notes

To send and receive messages after the message buffer has been disabled, use the ENABLE procedure.