Notes

Error code -84, SQL state 42612: [SQL0084] SQL statement not allowed. Cause . . . . . : The SQL statement is not allowed for one of the following reasons: -- DECLARE CURSOR, DECLARE STATEMENT, FETCH, OPEN, CLOSE, WHENEVER, PREPARE, EXECUTE, EXECUTE IMMEDIATE, INCLUDE, DECLARE VARIABLE, DECLARE PROCEDURE, DESCRIBE, GET DIAGNOSTICS, SIGNAL, RESIGNAL, SET variable, ALLOCATE DESCRIPTOR, DEALLOCATE DESCRIPTOR, GET DESCRIPTOR, and SET DESCRIPTOR are not allowed in interactive SQL, dynamic SQL, or when using the RUNSQLSTM command. -- BEGIN DECLARE SECTION and END DECLARE SECTION are not allowed in interactive SQL, in dynamic SQL, in RPG, or in REXX. -- A blocked INSERT statement is not allowed in interactive SQL or dynamic SQL. -- The CONNECT, SET CONNECTION, RELEASE, and DISCONNECT statements are not allowed in dynamic SQL or REXX. CONNECT with constants specified for user ID and password is not allowed in a precompiled program. -- SET ENCRYPTION PASSWORD with constants specified for user ID or hint is not allowed in a precompiled program. -- SELECT and VALUES cannot be issued from an EXECUTE IMMEDIATE statement or the RUNSQLSTM command. -- The SET OPTION statement is only allowed in REXX, in a precompiled program, or in SQL routines. In a precompiled program, it must be the first SQL statement in the program. -- DECLARE STATEMENT, DECLARE VARIABLE, DECLARE PROCEDURE, GET DIAGNOSTICS, INCLUDE, SELECT INTO, SET CURRENT DEGREE, SET RESULT SETS, SIGNAL, WHENEVER, blocked INSERT, blocked FETCH, locator statements, and SQL descriptor statements are not allowed in REXX. -- The SET TRANSACTION statement is not allowed when the current connection is to a remote database. -- The SET SESSION AUTHORIZATION statement can only be run in the default activation group. It is not allowed in REXX, or when using the RUNSQLSTM command. -- The SQL statement specified is not a valid statement on the current release of DB2 for i5/OS. The statement may be valid on a future release of DB2 for i5/OS or on some other system's implementation of SQL. Recovery . . . : The statement cannot be run in this mode. For a CONNECT or SET ENCRYPTION PASSWORD statement in a precompiled program, specify host variables instead of constants. If in interactive SQL, you may syntax check a statement by setting the statement processing value to *SYN.