Informix Error -29035: An incompatible data type was received by the Gateway.
Cause and resolution
An incompatible data type was received by the Gateway.
The received data type is not compatible with or supported by the Gateway. (For IBM Informix Enterprise Gateway with DRDA, the application requestor does not support the data type that was received from the application server.)
Some examples of unsupported data types are 1-byte integer and 16-byte float. These data types are not supported.
Do not retrieve data from the columns that have data types that the Gateway cannot support.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-29035 fires when the Gateway (for DRDA-based gateways, the application requestor) receives a data type it doesn't support — per the official guidance, examples of unsupported types include 1-byte integer and 16-byte float.
- A column of an unsupported data type being retrieved through the Gateway, per the official guidance — the direct, only cause.
Solutions / Resolution
- Don't retrieve data from columns whose data types the Gateway doesn't support, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond retrieving an unsupported data type (e.g. 1-byte integer or 16-byte float).
Diagnostic Checks
- Check the data types of the columns being retrieved through the Gateway, and avoid any unsupported ones.
Related Errors / Related Topics
- -29030 — "Feature feature-name not supported by the Gateway." A related Gateway-unsupported-element error, on a general feature rather than a specific data type received from the application server.
The Gateway received a data type it doesn't support (e.g. 1-byte integer, 16-byte float) — avoid retrieving those columns.