Informix Error -2953: The name name is not a database column in this form.

Reasons / Common Causes

-2953 fires when a name listed in a COMPOSITES list isn't defined in ATTRIBUTES — per the official guidance, all columns named in a COMPOSITES list must be defined in the ATTRIBUTES section.

1. A name in COMPOSITES that was never defined in ATTRIBUTES, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Check the spelling of all the names, per the official guidance.
2. Make sure they have been defined in ATTRIBUTES, per the official guidance.

Examples

A COMPOSITES name missing from ATTRIBUTES

ATTRIBUTES
  street = street;
  city = city;
  state = state;

COMPOSITES
  street, city, state, zip_code;
-- -2953: zip_code is listed in COMPOSITES but never defined in ATTRIBUTES

Corrected

ATTRIBUTES
  street = street;
  city = city;
  state = state;
  zip_code = zip_code;

Diagnostic Checks

1. Check every name listed in COMPOSITES against the ATTRIBUTES section, and add or correct any that are missing.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -2953 in this set yet.

A name listed in COMPOSITES isn't defined in ATTRIBUTES — check its spelling and add the missing definition.