Informix Error -29039: Cannot have more than one SQL statement in PREPARE/EXECUTE IMMEDIATE.
Cause and resolution
Cannot have more than one SQL statement in PREPARE/EXECUTE IMMEDIATE.
Modify the application so that it does not include more than one SQL statement in a PREPARE or EXECUTE IMMEDIATE statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-29039 fires when a PREPARE/EXECUTE IMMEDIATE statement string contains more than one
SQL statement — per the official guidance.
- Multiple SQL statements in a single
PREPARE/EXECUTE IMMEDIATEstring, per the official guidance — the direct, only cause.
Solutions / Resolution
- Modify the application so
PREPARE/EXECUTE IMMEDIATEcontains only one SQL statement, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond multiple statements in one
PREPARE/EXECUTE IMMEDIATE.
Diagnostic Checks
- Check the
PREPARE/EXECUTE IMMEDIATEstatement string, and split it into separate calls if it contains more than one statement.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -29039 in this set yet.
A PREPARE/EXECUTE IMMEDIATE string contained more than one SQL statement — split it
into separate calls.