The CURRENT DEBUG MODE special register specifies whether SQL or Java procedures should be created or altered so they can be debugged by the Unified Debugger. Any explicit specification of the DEBUG MODE or the DBGVIEW option in the SET OPTION statement on the CREATE PROCEDURE or ALTER PROCEDURE statement overrides the value in the CURRENT DEBUG MODE special register. CURRENT DEBUG MODE affects static and dynamic SQL statements. The data type of the register is VARCHAR(8). The valid values include:
The value can be changed by invoking the SET CURRENT DEBUG MODE statement. For details about this statement, see SET CURRENT DEBUG MODE.
The initial value of CURRENT DEBUG MODE is DISALLOW.
The following statement prevents subsequent creates or alters of SQL or Java procedures from being debuggable:
SET CURRENT DEBUG MODE = DISALLOW
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.