Transient types on high-availability cluster secondary servers

Transient unnamed complex data types (ROW, SET, LIST, and MULTISET) can be used on high-availability cluster secondary servers, whether the secondary servers are read-only or updatable. The following types of operations that use transient types are supported on secondary servers:
  • SQL queries that use transient types
  • SQL queries that use derived tables, collection subqueries, and XML functions (these statements implicitly use transient types)
  • Temporary tables created with the CREATE TEMP statement that uses transient types

See the IBM® Informix® Guide to SQL: Reference and IBM Informix Guide to SQL: Syntax for information about complex data types.


Copyright© 2018 HCL Technologies Limited