Informix Error -25729: Type <opaque_type_name> may not be used in a distributed query </opaque_type_name> (DONOTDISTRIBUTE).
Cause and resolution
Type <opaque_type_name> may not be used in a distributed query </opaque_type_name> (DONOTDISTRIBUTE).
The user-defined type <opaque_type_name> was created with the DONOTDISTRIBUTE modifier. UDTs with the DONOTDISTRIBUTE attribute cannot be used in queries that access more than one database. </opaque_type_name>
Modify the query or change the attributes of the <opaque_type_name> data type. </opaque_type_name>
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25729 fires when a query accessing more than one database uses a UDT created with the
DONOTDISTRIBUTE modifier — per the official guidance, such types can't be used in
distributed queries.
- A
DONOTDISTRIBUTEUDT used in a query accessing more than one database, per the official guidance — the direct, only cause.
Solutions / Resolution
- Modify the query to avoid the type, per the official guidance, or
- Change the type's attributes to remove
DONOTDISTRIBUTE, per the official guidance, if distribution is actually needed.
Examples
N/A
No specific triggering statement is documented beyond a DONOTDISTRIBUTE type used in a
multi-database query.
Diagnostic Checks
- Check whether the query accesses more than one database, and whether any UDT
involved has the
DONOTDISTRIBUTEmodifier.
Related Errors / Related Topics
- -25736 — "The extended type <data_type_name> has not been defined in the local database." A related distributed-query UDT error, on the type being undefined locally rather than explicitly excluded from distribution.
A DONOTDISTRIBUTE UDT was used in a distributed query — modify the query, or remove the
DONOTDISTRIBUTE attribute if distribution is needed.