DB2 Version 10.1 for Linux, UNIX, and Windows

PUT_LINE procedure - Put a complete line in the message buffer

The PUT_LINE procedure puts a single line that includes an end-of-line character sequence in the message buffer.

Syntax


>>-DBMS_OUTPUT.PUT_LINE--(--item--)----------------------------><

Procedure parameters

item: An input argument of type VARCHAR(32672) that specifies the text to write to the message buffer.

Authorization

EXECUTE privilege on the PUT_LINE procedure.

Example

Use the PUT_LINE procedure to write a line that includes an end-of-line character sequence to the message buffer.

SET SERVEROUTPUT ON@

CREATE PROCEDURE PROC1()
BEGIN
  CALL DBMS_OUTPUT.PUT( 'a' ); 
  CALL DBMS_OUTPUT.NEW_LINE; 
  CALL DBMS_OUTPUT.PUT_LINE( 'b' ); 
END@

CALL PROC1@

SET SERVEROUTPUT OFF@

This example results in the following output:

a
b