logo  
Google
 

DB2 SQL-Error: -084

SQLState: 42612

Short Description: UNACCEPTABLE SQL STATEMENT

This SQL statement is unacceptable to DB2. One of the following has occurred: v An attempt has been made to PREPARE or EXECUTE IMMEDIATE an SQL statement that cannot be prepared; refer to the proper SQL statement in DB2 SQL Reference v The embedded SQL statement is not an SQL statement supported by DB2. v The statement referenced an undeclared cursor. v 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 executed. Programmer response: If the situation involves an SQL statement that cannot be prepared, the problem is in the source of the SQL statement, not the application © Copyright IBM Corp. 1982, 2007 29########### #program. Thus, no action is necessary unless the source of the SQL statement is the application program itself. If the situation involves an SQL statement that is not supported by DB2, remove it from the application program and precompile again. If the situation involves an invalid PREPARE of an ALLOCATE CURSOR statement, change the application program to use a statement identifier that is not associated with a declared cursor.

 <-  BACK TO INDEX