DSN8.DISABLE stored procedure

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

Environment

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

Syntax

Read syntax diagramSkip visual syntax diagram CALL DSN8.DISABLE

Notes

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

Examples

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

CALL DSN8.DISABLE;