Informix Error -25736: The extended type <data_type_name> has not been defined in the </data_type_name> local database.
Cause and resolution
The extended type <data_type_name> has not been defined in the </data_type_name> local database.
The data type <data_type_name> does not have a definition on the local database. All extended data types that are used in distributed queries must be defined in both the local and remote databases. </data_type_name>
Make sure that <data_type_name> is defined in both the local and remote databases and that the definitions have the same attributes. </data_type_name>
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25736 fires when an extended data type used in a distributed query isn't defined in the local database — per the official guidance, all extended types used in distributed queries must be defined in both the local and remote databases.
- An extended type used in a distributed query but not defined locally, per the official guidance — the direct, only cause.
Solutions / Resolution
- Define the type in the local database, matching the remote database's definition's attributes, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an extended type missing locally.
Diagnostic Checks
- Check whether the type is defined locally, and create a matching definition if not.
Related Errors / Related Topics
- -25728 — "Type <data_type_name> is not the same in the local and remote database." A related distributed-query UDT error, on the type being defined but mismatched, rather than entirely undefined locally.
- -25729 — "Type <opaque_type_name> may not be used in a distributed query (DONOTDISTRIBUTE)." A related distributed-query UDT restriction, on a type explicitly excluded from distribution.
An extended type used in a distributed query wasn't defined in the local database — define it locally, matching the remote definition.