Informix Error -26016: Illegal leading byte 0x20 in Index name (index_name).
Cause and resolution
Illegal leading byte 0x20 in Index name (index_name).
In some situations, such as when a constraint is defined, the database server creates indexes internally. These indexes, by convention, always have a leading ASCII blank (hex 20) as the first byte of their name. To avoid a conflict, user-created indexes cannot have an ASCII blank (hex 20) as the first byte of their name. Also, there can be no reference to indexes with a leading blank in any user-issued statements. This rule is enforced regardless of the locale. This rule is also enforced regardless of the use of the DELIMIDENT environment variable.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26016 fires when a user-created index name starts with an ASCII blank (hex 20) — per the official guidance.
- A user-created index name starting with an ASCII blank, per the official guidance —
reserved for the server's own internally-created indexes (e.g. for constraints), which
always use a leading blank by convention; enforced regardless of locale or the
DELIMIDENTenvironment variable.
Solutions / Resolution
- Rename the index so it doesn't start with an ASCII blank, per the official guidance.
Examples
An index name with a leading blank
CREATE INDEX " my_idx" ON orders (order_id);
-- -26016: leading ASCII blank reserved for server-internal indexes
Corrected
CREATE INDEX my_idx ON orders (order_id);
Diagnostic Checks
- Check the index name for a leading ASCII blank, and rename it if present.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -26016 in this set yet.
A user-created index name started with an ASCII blank, reserved for server-internal indexes — rename the index.