Informix Error -4152: Invalid begin or end name for THROUGH expression.

Reasons / Common Causes

-4152 fires when an SQL statement's THROUGH expression uses invalid begin or end expressions — per the official guidance, this is a general validity failure for the names used in that expression.

1. An invalid begin or end expression in an SQL THROUGH clause, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Review the THROUGH expression's begin and end names, and correct them to valid column references.

Examples

An invalid THROUGH expression

SELECT order_id THROUGH invalid_col FROM orders;

Corrected

SELECT order_id THROUGH order_date FROM orders;

Diagnostic Checks

1. Check both names in the SQL statement's THROUGH expression, and confirm they're valid column references.

Related Errors / Related Topics

• -4018 — "The columns specified in the THRU option do not belong to the same table." A related THRU/THROUGH error in the 4GL form-compiler context rather than SQL.
• -4019 — "The columns specified in the THRU option appear in the reverse order." A related THRU/THROUGH error, about ordering rather than general validity.
• -4073 — "Beginning or ending name in THRU specification is not a member of the target record." A related THRU-specification error in the class/record context rather than SQL.

An SQL THROUGH expression's begin or end name is invalid — check both names.