Informix Error -47098: Number of columns in composite list exceeds maximum.
Cause and resolution
Number of columns in composite list exceeds maximum.
You cannot include more than 16 column names in a single primary or unique constraint on IBM Informix Dynamic Server. Reduce the number of columns that are specified in the constraint definition.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-47098 fires in the interactive ALTER TABLE menu when a primary or unique constraint
names more than 16 columns — per the official guidance, that's the maximum on IBM Informix
Dynamic Server.
- More than 16 columns specified in a single primary/unique constraint, per the official guidance — the direct, only cause.
Solutions / Resolution
- Reduce the number of columns in the constraint definition, per the official guidance, to 16 or fewer.
Examples
N/A
No specific triggering statement is documented beyond this menu-driven column-count restriction.
Diagnostic Checks
- Count the columns in the composite constraint, and reduce to 16 or fewer.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -47098 in this set yet.
A composite primary/unique constraint named more than 16 columns — reduce it to 16 or fewer.