Oninit
Talk to an expert →

Informix Error -7421: The specified column position is invalid.

Cause and resolution

The specified column position is invalid.

Check the arguments to the DataBlade API calls that require column numbers. DataBlade API calls use column numbers 0 to number of columns minus one.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-7421 fires when a DataBlade API call receives an invalid column number — per the official guidance, column numbers must be 0 to the number of columns minus one.

  1. A column number outside the valid 0-to-(columns-1) range, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Check the arguments to DataBlade API calls that require column numbers, per the official guidance, and confirm the value is within 0 to the number of columns minus one.
Examples
An out-of-range column number
mi_value_by_pos(conn, row_value, num_columns, ...);
/* -7421: num_columns is one past the last valid index (0..num_columns-1) */
Diagnostic Checks
  1. Check every column-number argument in DataBlade API calls, and confirm it's within 0 to the number of columns minus one.
Related Errors / Related Topics
  • -7420 — "Argument argument_name is invalid." The general version of this same class of DataBlade API argument-validity error.

A DataBlade API call's column number is outside 0 to (columns − 1) — correct it.