Start of change

DSN8.ENABLE stored procedure

The ENABLE sample procedure enables the message buffer into which trace messages for native SQL routines are written.

Environment

The ENABLE 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.ENABLE stored procedure
  • Ownership of the stored procedure
  • SYSADM authority

Syntax

Read syntax diagramSkip visual syntax diagram CALL DSN8.ENABLE ( buffer-size )

Option descriptions

buffer-size
This value is not used by DSN8.ENABLE.

This is an input argument of type INTEGER.

Notes

Creation of this procedure:
Sample job DSNTEJTR creates this procedure.

Examples

Example: Enable the message buffer for the current debug session.

CALL DSN8.ENABLE(17000);

Example: Enable the message buffer for the current debug session, without specifying the buffer-size parameter.

CALL DSN8.ENABLE(CAST(NULL AS INTEGER));
End of change