Informix Error -26362: Invalid data type for 'hash on' columns specified for FOT index.
Cause and resolution
Invalid data type for 'hash on' columns specified for FOT index.
The 'hash on' columns for the forest of trees (FOT) index must be built-in data types.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26362 fires when a forest-of-trees (FOT) index's HASH ON columns aren't built-in data
types — per the official guidance.
- One or more
HASH ONcolumns aren't built-in data types, per the official guidance — the direct, only cause.
Solutions / Resolution
- Use only built-in data types for
HASH ONcolumns, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a non-built-in HASH ON column
type.
Diagnostic Checks
- Check the data type of every
HASH ONcolumn, and confirm each is a built-in type.
Related Errors / Related Topics
- -26360 — "Invalid bucket size specified for FOT index." A related FOT-index definition error, on the bucket size rather than hash-on column data types.
- -26361 — "Invalid 'hash on' list specified for FOT index." A related FOT-index definition error, on the list's prefix requirement rather than data types.
An FOT index's HASH ON columns weren't built-in data types — use only built-in types.