Informix Error -23745: CREATE EXTERNAL TABLE: Internal column types must be defined column-name.
Cause and resolution
CREATE EXTERNAL TABLE: Internal column types must be defined column-name.
The CREATE EXTERNAL TABLE statement requires a column type for each column enumerated in the statement.
Revise the statement. Add the appropriate column type and then reissue the statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23745 fires when a CREATE EXTERNAL TABLE statement omits a column type for one of
its enumerated columns — per the official guidance.
- A missing column type for an enumerated column, per the official guidance — the direct, only cause.
Solutions / Resolution
- Add the appropriate column type and reissue the statement, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a missing internal column type.
Diagnostic Checks
- Check every enumerated column for a declared internal column type, and add any missing one.
Related Errors / Related Topics
- -23744 — "CREATE EXTERNAL TABLE: Cannot use SAMEAS for FIXED format tables." A
related column-definition error, on
SAMEASbeing disallowed rather than a missing column type.
An enumerated column was missing its internal column type — add it.