Informix Error -7542: Cast user-defined-routine lookup failed.

Reasons / Common Causes

-7542 fires when a lookup for a cast UDR fails — per the official guidance.

1. A misspelled or improperly defined type used in the cast routine's signature, per the official guidance — the direct, named cause.

Solutions / Resolution

1. Verify the spelling and definition of types used in the routine signature, per the official guidance.
2. If this error recurs, note all circumstances and contact IBM Informix Technical Support, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond a misspelled or improperly defined type in the cast routine's signature.

Diagnostic Checks

1. Check every type name in the cast routine's signature, and confirm it's spelled correctly and properly defined in the database.

Related Errors / Related Topics

• -7532 — "Error converting type in string format to id format" The same underlying type-resolution issue, for routine signatures generally rather than cast routines specifically.

A cast UDR lookup failed — check the spelling and definition of the types in its signature.