-084 UNACCEPTABLE SQL STATEMENT

Explanation

This SQL statement is unacceptable to Db2. One of the following situations has occurred:
  • An attempt has been made to PREPARE or EXECUTE IMMEDIATE an SQL statement that cannot be prepared.
  • The embedded SQL statement is not an SQL statement supported by Db2.
  • The statement referenced an undeclared cursor.
  • An attempt was made to prepare an ALLOCATE CURSOR statement but the statement identifier is already associated with a declared cursor.
  • A statement that is to be processed remotely referenced an array variable or array element. The remote execution is the result of one of the following actions:
    • Previous execution of a CONNECT statement
    • Use of a three-part name or alias in the current statement that resolves to an object at a remote server

    A statement that is executed remotely cannot reference an array, except in the following cases:

    • The statement is a CALL statement.
    • An array element in the statement is a target of a FETCH, SELECT INTO, SET assignment-statement, or VALUES INTO statement.

System action

The statement cannot be processed.

Programmer response

Perform one of the following actions, depending on the situation:

  • If the SQL statement cannot be prepared, the problem is in the source of the SQL statement, not the application program. Thus, no action is necessary unless the source of the SQL statement is the application program itself.
  • If the SQL statement is not supported by Db2, remove it from the application program and precompile again.
  • If an attempt was made to prepare an ALLOCATE CURSOR statement, change the application program to use a statement identifier that is not associated with a declared cursor.
  • If the SQL statement references an array, change the application program so that the statement does not execute on a remote server.

Routing code

42612