DSN8.PUT_LINE stored procedure
The PUT_LINE sample procedure writes a line, including the end-of-line character sequence, to the message buffer.
Environment
The PUT_LINE stored procedure must be called from within a native SQL routine.
Authorization
To execute the CALL statement, the owner of the package or plan that contains the CALL statement must have one or more of the following privileges:
- The EXECUTE privilege on the DSN8.PUT_LINE stored procedure
- Ownership of the stored procedure
- SYSADM authority
Syntax
Option descriptions
- item
- Specifies the line to write to the message buffer. If item is an empty string
or NULL, a null character is put in the message buffer.
This is an output argument of type VARGRAPHIC(16334).
Notes
- Creation of this procedure:
- Sample job DSNTEJTR creates this procedure.
Examples
Example: Write the string 'Hello' to the message buffer, with an end-of-line sequence at the end.
CALL DSN8.PUT_LINE('Hello');