Oninit
Talk to an expert →

Informix Error -4073

-4073 Beginning or ending name in THRU specification is not a member

of the target record.

This statement makes a reference to some structure (table, record, or object) with the qualification "first THRU (or THROUGH) last". However, first or last does not appear as an element of that aggregate. Check the spelling of the two names.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-4073 fires when a first THRU last (or THROUGH) qualification names a first or last that isn't actually an element of the referenced structure — per the official guidance, this applies to a table, record, or object.

  1. first or last isn't a member of the referenced structure, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Check the spelling of both names, per the official guidance.
Examples
A THRU range naming a nonexistent member
DISPLAY rec.order_id THRU rec.order_staus
-- -4073: "order_staus" is misspelled and not a member of rec
Corrected
DISPLAY rec.order_id THRU rec.order_status
Diagnostic Checks
  1. Check the spelling of both THRU-range names against the actual members of the referenced structure.
Related Errors / Related Topics
  • -4018 — "The columns specified in the THRU option do not belong to the same table." A related THRU-option error, about the two names belonging to different tables rather than one not existing at all.
  • -4019 — "The columns specified in the THRU option appear in the reverse order." A related THRU-option error, about column ordering rather than a nonexistent member name.

A THRU-range name isn't actually a member of the referenced structure — check its spelling.