Informix Error -1350
Cause and resolution
It is not possible to convert between the specified types.
The system will attempt any data conversion that makes sense. However, some conversions, such as INTERVAL to DATE, or DATETIME to MONEY, are not supported. Possibly you referenced the wrong variable or column. Check that you have specified the data types that you intended and that you formatted literal representations of data values correctly.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-1350 is the 4GL-program equivalent of -1260: it fires when a conversion is attempted between
two types the system doesn't support converting between — per the official guidance, named
examples include INTERVAL to DATE and DATETIME to MONEY.
- A conversion between two fundamentally incompatible types, per the official guidance's named examples — the same direct cause as -1260.
- A literal data value not formatted correctly for its intended type, per the official guidance's other suggested check.
Solutions / Resolution
- Verify that the correct data types were specified, per the official guidance — see -1260 for the full detail.
- Verify that literal data values are properly formatted, per the official guidance.
- Review variable and column references to ensure the intended types were selected, per the official guidance's own additional note.
Examples
N/A
This is the 4GL-program wording of -1260's condition — see -1260's examples for the underlying unsupported-conversion mechanism.
Diagnostic Checks
- Check the source and target types involved against the documented supported-conversions list, per -1260's diagnostic approach.
Related Errors / Related Topics
- -1260 — "It is not possible to convert between the specified types." The non-4GL wording of this same unsupported-conversion condition.
The 4GL-program wording of -1260's unsupported-conversion condition — see -1260 for the full detail.