Informix Error -4302: The record description is nested too deep.

Reasons / Common Causes

-4302 fires when a record definition nests records within records beyond five levels — per the official guidance, this is a hard limit on nested record depth.

1. A record definition nesting records more than five levels deep, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Rewrite the record definition so it doesn't exceed five nested levels, per the official guidance — for example, by flattening some of the inner structure.

Examples

An overly deep record nesting

DEFINE rec RECORD
  a RECORD
    b RECORD
      c RECORD
        d RECORD
          e RECORD
            f INTEGER
          END RECORD
        END RECORD
      END RECORD
    END RECORD
  END RECORD
END RECORD
-- -4302: six levels of nesting exceeds the limit of five

Corrected

Flatten one or more of the inner record levels into simple fields at a shallower level.

Diagnostic Checks

1. Count the nesting depth of the record definition, and flatten it if it exceeds five levels.

Related Errors / Related Topics

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

A record definition nests more than five levels deep — flatten the structure.