DB2 SQL-Error: -423
SQLState: 38503
Short Description: INVALID VALUE FOR LOCATOR IN POSITION C E SQL LOB S T P F T R DESCRIBE PROCEDURE ASSOCIATE LOCATORS M R SQL I SQL F LOB T LOB LOB A SQL FREE LOCATOR F SQLSTATE F DYNAMIC COMMIT NOT VALID AT AN APPLICATION SERVER WHERE UPDATES ARE NOT ALLOWED DYNAMIC ROLLBACK NOT VALID AT AN APPLICATION SERVER WHERE UPDATES ARE NOT ALLOWED SPECIFIC NAME HAS ABNORMALLY TERMINATED
The value specified in a result set locator host variable, a LOB locator host variable, or a table locator that is specified at position position-# in the locator variable list of the SQL statement does not Explanation: An application executing using DRDA protocols has attempted to issue a dynamic COMMIT statement, or a stored procedure has attempted to issue a COMMIT_ON_RETURN, while connected to a location at which updates are not allowed. A dynamic COMMIT or COMMIT_ON_RETURN can be issuedonly while connected to a location at which updates are allowed. System action: The statement cannot be executed. No COMMIT is performed. Programmer response: The IMS or CICS protocols should be used to commit work in these environments. SQLSTATE: 2D528 Explanation: An application executing using DRDA protocols has attempted to issue a dynamic ROLLBACK statement while connected to a location at which updates are not allowed. A dynamic ROLLBACK may be issued only while connected to a location at which updates are allowed. System action: The statement cannot be executed. No ROLLBACK is performed. Programmer response: The IMS or CICS protocols should be used to rollback work in these environments. SQLSTATE: 2D529 Explanation: An abnormal termination has occurred while the routine routine-name (stored procedure or function) was in control. System action: The statement cannot be executed. Programmer response: The stored procedure or function needs to be fixed. Contact the author of the routine or your database administrator. Until it is fixed, the routine should not be used.