DSN8.PUT stored procedure
The PUT sample procedure writes a line to the message buffer, without an end-of-line character sequence at the end.
Environment
The PUT 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 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, the message buffer is unmodified.
This is an output argument of type VARGRAPHIC(16334).
Notes
- Creation of this procedure:
- Sample job DSNTEJTR creates this procedure.
- Adding an end-of-line character sequence to the end of the message buffer:
- When you use the DSN8.PUT procedure to write a string to the message buffer, you can use the NEW_LINE procedure to add the end-of-line character sequence to the end of the message buffer.
Examples
Example: Write the string 'Hello' to the message buffer, without an end-of-line character sequence at the end.
CALL DSN8.PUT('Hello');