Data Types in Distributed Queries (IDS)

In Dynamic Server, a query that accesses tables in a database of another database server can only reference built-in data types that are not opaque, nor extended, nor large-object data types. Cross-server queries cannot reference a column or expression of an opaque, DISTINCT, or user-defined data type (UDT).

Distributed queries that access other databases of the local Dynamic Server instance, however, can also access most built-in opaque data types, which are listed in BOOLEAN and Other Built-In Opaque Data Types (IDS).

Queries across databases of the local Dynamic Server instance can also reference UDTs, as well as DISTINCT types based on built-in data types, if all the UDTs and DISTINCT types are explicitly cast to built-in data types, and all the UDTs, DISTINCT types, and casts are defined in each of the participating databases.

A distributed query can use both the 3SKIP and FIRST options if all participating servers support the 3SKIP option; otherwise the query fails with an error.

Queries cannot access a database of another database server unless both servers define TCP/IP connections in DBSERVERNAME or DBSERVERALIAS configuration parameters. This applies to any communication between Dynamic Server instances, even if both database servers reside on the same computer.