Informix Error -1816: No such column exists in the collection or row.
Cause and resolution
No such column exists in the collection or row.
The field name specified by the application does not exist in the description of the collection or row host variable. Check the description of the field names within the declaration and make sure the field name specified matches the one in the declaration.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-1816 fires when a field name referenced by the application doesn't exist in the collection or row host variable's own description — per the official guidance, this is a name mismatch between the declared type and the field actually referenced.
- A field name referenced that doesn't match any field in the row/collection's declared type, per the official guidance — the direct, only cause.
Solutions / Resolution
- Verify that field names in your declaration match the ones being referenced in your code, per the official guidance.
Examples
A field name mismatch
$ROW(order_id INTEGER, status CHAR(10)) *order_row;
-- code later references a field "order_status" instead of "status"
-- -1816: order_row has no field named order_status
Corrected
-- reference the actual declared field name: status
Diagnostic Checks
- Compare the field name referenced in the code against the row/collection's actual declared field names.
Related Errors / Related Topics
- -1814 — "Need to allocate collection or row variable before using it." A related complex-type error, about a missing allocation.
- -1815 — "No type information for collection or row is available." A related complex-type error, about a missing type declaration entirely.
A referenced field name doesn't match the row/collection's declared type — compare the field name against the declaration.