Previous Topic: IDAETDVW22 - Ideal access to CADATACOM CBS is disabledNext Topic: IDAETDVW24 - CBS internal error, CADATACOM RC=91-return-code


IDAETDVW23 - Invalid DB2 PREPARE or EXECUTE IMMEDIATE SQL detected

Reason:

CA Ideal is executing in SQL mode MIXED and executed a PREPARE or EXECUTE SQL statement to execute SQL access in dynamic SQL. The SQL string passed to the DBMS was rejected with SQLCODE=-198, indicating that SQL generated by (or allowed to pass the compiler in) CA Ideal is invalid.

Action:

If the statement is a CA Ideal FOR construct, the CA Ideal compiler generated invalid DB2 SQL. Contact CA Technical Support. Obtain information as illustrated in the CA Ideal Problem Determination Guide to facilitate your call.

If the statement is a user-coded EXEC SQL, verify that IBM DB2 can execute the SQL. If not, modify the SQL. If so, notify CA Technical Support.