-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.

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.

Routing code

42612