Oninit
Talk to an expert →

Informix Error -2930: Portions of the column name are displayed on the screen more than once.

Cause and resolution

Portions of the column name are displayed on the screen more than once.

This form displays subscripted portions of the indicated column in different fields. This situation is permitted; however, no single character can appear in more than one field. That is, the subscripts cannot overlap. For example, you can display name[25,49] in one field and name[50,74] in another. You cannot display name[25,49] and name[25,74] because some characters would be displayed twice.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-2930 fires when a form displays overlapping subscripted portions of the same column in different fields — per the official guidance, displaying non-overlapping substrings (e.g. name[25,49] in one field and name[50,74] in another) is permitted, but no single character may appear in more than one field, so overlapping ranges (e.g. name[25,49] and name[25,74]) are rejected.

  1. Two or more display fields whose column-substring subscripts overlap, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Adjust the subscripts so the ranges don't overlap, per the official guidance — for example, split the column into contiguous, non-overlapping ranges like [25,49] and [50,74].
Examples
Overlapping subscripts
ATTRIBUTES
  first_half = name[25,49];
  second_half = name[25,74];
-- -2930: both ranges include characters 25-49
Corrected
ATTRIBUTES
  first_half = name[25,49];
  second_half = name[50,74];
Diagnostic Checks
  1. Check every subscripted display of the same column for overlapping ranges, and adjust the bounds so each character appears in only one field.
Related Errors / Related Topics
  • -2870 — "The subscripted column size does not match the space allocated in the display field." A related column-substring error, about a substring/field-width mismatch rather than overlapping ranges across fields.
  • -2950 — "The column name has no section which starts at 1." A related overlap error, about a missing starting section or 0-based subscripting specifically, rather than overlapping ranges generally.

Two display fields show overlapping portions of the same column — adjust the subscripts so the ranges don't overlap.