DSN8.NEW_LINE stored procedure
The NEW_LINE sample procedure writes an end-of-line character sequence to the message buffer.
Each line of text in the message buffer, up to, but not including the end-of-line
character, is stored in an element of the target array.
Environment
The NEW_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.NEW_LINE stored procedure
- Ownership of the stored procedure
- SYSADM authority
Syntax
Notes
- Creation of this procedure:
- Sample job DSNTEJTR creates this procedure.
Examples
Example: Write an end-of-line character sequence to the message buffer.
CALL DSN8.NEW_LINE;