Informix Error -2944: You may apply the after add, update, query, or remove commands to a table only -- not a column.
Cause and resolution
You may apply the after add, update, query, or remove commands to a table only -- not a column.
The operations of Add, Update, Remove, and Query all apply to whole rows. Consequently, these control blocks must list only table names, not names of individual columns, in their opening command. Review the names in this statement, and change column names to the names of their tables.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-2944 fires when an AFTER ADD/UPDATE/QUERY/REMOVE control block names a column instead
of a table — per the official guidance, these operations apply to whole rows, so their opening
command must list only table names, not individual column names.
- A column name used in the opening command of an
AFTER ADD/UPDATE/QUERY/REMOVEblock, per the official guidance — the direct, only cause.
Solutions / Resolution
- Review the names in the statement, and change column names to the names of their tables, per the official guidance.
Examples
A column name where a table name is required
AFTER UPDATE OF order_date
...
-- -2944: order_date is a column, not a table
Corrected
AFTER UPDATE OF orders
...
Diagnostic Checks
- Check every
AFTER ADD/UPDATE/QUERY/REMOVEopening command for column names, and replace them with the enclosing table's name.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -2944 in this set yet.
An AFTER ADD/UPDATE/QUERY/REMOVE block names a column instead of a table — these
row-level operations require table names only.