Informix Error -26363: FOT indexes cannot be functional indexes.
Cause and resolution
FOT indexes cannot be functional indexes.
The 'hash on' columns for the forest of trees (FOT) index must be built-in data types.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26363 fires when a forest-of-trees (FOT) index is defined as a functional index — per the official guidance's title; the live page's body paragraph is a copy-paste duplicate of -26362's body text ("hash on columns must be built-in data types") rather than text actually describing this title, a site-content anomaly transcribed faithfully rather than silently corrected.
- The index is defined as a functional index (indexing an expression rather than plain columns), per the official guidance's title — the direct, only cause; not supported for FOT indexes.
Solutions / Resolution
- Define the index on plain columns instead of a function/expression, per the official guidance's title.
Examples
N/A
No specific triggering statement is documented; the live page's body text describes an unrelated condition (see Reasons above).
Diagnostic Checks
- Check whether the FOT index definition indexes a function/expression, and redefine it on plain columns if so.
Related Errors / Related Topics
- -26362 — "Invalid data type for 'hash on' columns specified for FOT index." The code whose body text is duplicated on -26363's own live page — a site-content anomaly, not a substantive relationship between the two conditions.
- -26364 — "Attached FOT indexes are not supported." A related FOT-index restriction, on attached indexes rather than functional indexes.
- -26365 — "Clustered FOT indexes are not supported." A related FOT-index restriction, on clustered indexes rather than functional indexes.
An FOT index was defined as a functional index, which isn't supported — define it on plain columns instead.