Informix Error -23771: Internal type must be a numeric type column-name.
Cause and resolution
Internal type must be a numeric type column-name.
The CREATE EXTERNAL TABLE statement contains external-column types that do not agree with the internal-column type. Whenever the external- column type is PACKED, ZONED or BINARY, the internal type must be a numeric type such as INTEGER, SMALLINT, FLOAT, or DECIMAL.
Check the CREATE EXTERNAL TABLE statement to make sure any external- column types agree with the internal-column type.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23771 fires when a column's external type (PACKED, ZONED, or BINARY) doesn't
agree with its internal type — per the official guidance, these external types require
a numeric internal type such as INTEGER, SMALLINT, FLOAT, or DECIMAL.
- A
PACKED/ZONED/BINARYexternal type paired with a non-numeric internal type, per the official guidance — the direct, only cause.
Solutions / Resolution
- Make the internal-column type numeric (
INTEGER/SMALLINT/FLOAT/DECIMAL), per the official guidance, to match the external type.
Examples
N/A
No specific triggering statement is documented beyond a numeric/non-numeric type mismatch.
Diagnostic Checks
- Check the flagged column's internal type against its external type, and make
the internal type numeric if the external type is
PACKED/ZONED/BINARY.
Related Errors / Related Topics
- -23772 — "Internal type must be a small integer or integer column-name." A
related type-agreement error, specific to
BINARYexternal types needingSMALLINT/INTEGERrather than any numeric type.
A PACKED/ZONED/BINARY external type was paired with a non-numeric internal type —
make the internal type numeric.