DB2 10.5 for Linux, UNIX, and Windows

ENABLE procedure - Enable the message buffer

The ENABLE procedure enables the message buffer. During a single session, applications can put messages in the message buffer and get messages from the message buffer.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_OUTPUT.ENABLE--(--buffer_size--)-----------------------><

Procedure parameters

buffer_size
An input argument of type INTEGER that specifies the maximum length of the message buffer in bytes. If you specify a value of less than 2000 for buffer_size, the buffer size is set to 2000. If the value is NULL, then the default buffer size is 20000.

Authorization

EXECUTE privilege on the DBMS_OUTPUT module.

Example

The following example enables the message buffer: 

CALL DBMS_OUTPUT.ENABLE( NULL )@

Usage notes

You can call the ENABLE procedure to increase the size of an existing message buffer. Any messages in the old buffer are copied to the enlarged buffer.