Informix Error -23744: CREATE EXTERNAL TABLE: Cannot use SAMEAS for FIXED format tables.
Cause and resolution
CREATE EXTERNAL TABLE: Cannot use SAMEAS for FIXED format tables.
The CREATE EXTERNAL TABLE statement does not allow SAMEAS for FIXED format tables. The column entries must also define an external type to describe how to access (or write) the data in the fixed file.
Revise the CREATE EXTERNAL TABLE statement to enumerate the column information and reissue the statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23744 fires when SAMEAS is used on a FIXED-format external table — per the
official guidance, FIXED-format tables require each column to enumerate an external
type describing how to read/write the fixed file's data.
SAMEASused on aFIXED-format table, per the official guidance — the direct, only cause.
Solutions / Resolution
- Enumerate the column information explicitly instead of using
SAMEAS, per the official guidance, then reissue the statement.
Examples
N/A
No specific triggering statement is documented beyond SAMEAS on a FIXED-format
table.
Diagnostic Checks
- Check whether the table is
FIXED-format and usesSAMEAS, and replace it with explicit column definitions.
Related Errors / Related Topics
- -23745 — "CREATE EXTERNAL TABLE: Internal column types must be defined
column-name." A related column-definition error, on a missing column type rather
than using
SAMEAS.
SAMEAS was used on a FIXED-format external table, which isn't allowed — enumerate
column information explicitly.