Oninit
Talk to an expert →

Informix Error -22600: Invalid SQL type type-name. Internal error.

Cause and resolution

Invalid SQL type type-name. Internal error.

For this IBM Informix ESQL/FORTRAN preprocessor error, check the data type of the symbol. Type-name must be a valid SQL data type.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-22600 is an IBM Informix ESQL/FORTRAN preprocessor error — per the official guidance, the named type isn't a valid SQL data type.

  1. A symbol's type not being a valid SQL data type, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Check the symbol's data type and correct it to a valid SQL data type, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond an invalid SQL type name.

Diagnostic Checks
  1. Check the flagged symbol's declared type, and correct it to a valid SQL data type.
Related Errors / Related Topics
  • -22622 — "Type type-name is unknown." A related type-validity error, on an undeclared type rather than an invalid SQL type name.

A symbol's type wasn't a valid SQL data type — correct it.