Oninit
Talk to an expert →

Informix Error -26190: Insert into an external table must provide values for all columns in the table.

Cause and resolution

Insert into an external table must provide values for all columns in the table.

The INSERT statement does not list all the columns that the external table defines. When the database server unloads to an external table, all columns must have values described by the SELECT list.

Check the INSERT statement to make sure that all columns are included in the INSERT clause and that every column has a value supplied by the SELECT list.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-26190 fires when an INSERT unloading to an external table doesn't list every column the table defines — per the official guidance.

  1. The INSERT statement's column list omits one or more of the external table's columns, per the official guidance — the direct, only cause; every column must have a value from the SELECT list when unloading.
Solutions / Resolution
  1. Include every column of the external table in the INSERT clause, per the official guidance, with a corresponding value in the SELECT list.
Examples
N/A

No specific triggering statement is documented beyond an INSERT omitting columns.

Diagnostic Checks
  1. Compare the INSERT statement's column list against the external table's full column list, and add any missing columns with a matching SELECT-list value.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -26190 in this set yet.

An INSERT into an external table omitted one or more of its columns — include every column with a matching value.