Oninit
Talk to an expert →

Informix Error -4019

-4019 The columns specified in the THRU option appear in the reverse order.

This statement refers to some aggregate (table, record, or object) with the qualification "first THRU (or THROUGH) last." However, first and last do not appear in that order in the aggregate; last precedes first. Check the spelling of the two names. Make sure that the correct database is current at this point in the compilation (the most recent preceding DATABASE statement).

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-4019 fires when a first THRU last (or THROUGH) qualification's two names appear in the aggregate in the opposite order — per the official guidance, last actually precedes first in the referenced table, record, or object.

  1. first and last given in reverse of their actual order in the aggregate, per the official guidance — the direct, only cause.
  2. The wrong database was current at that point in compilation, per the official guidance — a related cause worth checking.
Solutions / Resolution
  1. Check the spelling of both names, per the official guidance.
  2. Make sure the correct database is current at this point (check the most recent preceding DATABASE statement), per the official guidance.
Examples
A reversed THRU range
DISPLAY orders.order_date THRU orders.order_id
-- -4019: order_id actually precedes order_date in the table
Corrected
DISPLAY orders.order_id THRU orders.order_date
Diagnostic Checks
  1. Check the actual column order in the referenced aggregate, and swap the THRU range's two names if they're reversed.
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 table membership rather than column ordering.

The two columns in a THRU/THROUGH range are given in reverse order — swap them to match their actual order in the aggregate.