Informix Error -23772: Internal type must be a small integer or integer column-name.
Cause and resolution
Internal type must be a small integer or integer 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 BINARY, the internal type must be SMALL INTEGER or INTEGER.
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
-23772 fires when a column's BINARY external type is paired with an internal type
other than SMALLINT/INTEGER — per the official guidance.
- A
BINARYexternal type paired with a non-SMALLINT/INTEGERinternal type, per the official guidance — the direct, only cause.
Solutions / Resolution
- Make the internal-column type
SMALLINTorINTEGER, per the official guidance, to match theBINARYexternal type.
Examples
N/A
No specific triggering statement is documented beyond a BINARY/non-integer type
mismatch.
Diagnostic Checks
- Check the flagged column's internal type, and correct it to
SMALLINT/INTEGERif the external type isBINARY.
Related Errors / Related Topics
- -23771 — "Internal type must be a numeric type column-name." The general
external/internal-type-agreement error this is a specific
BINARY/integer case of.
A BINARY external type was paired with an internal type other than SMALLINT/
INTEGER — correct the internal type.