Distributed Queries across Databases of One Dynamic Server Instance

Distributed operations across databases of the same IBM Informix Dynamic Server instance are subject to the following restrictions on returned data types:

• The query, DML operation, or function call can return any built-in data type, including BLOB, BOOLEAN, CLOB, and LVARCHAR built-in opaque types.
• The query, DML operation, or function call cannot return DISTINCT or OPAQUE data types unless these are explicitly cast to a built in data type, and all the DISTINCT and OPAQUE data types and all the explicit casts are defined in each participating database that stores or receives the data types.