Connecting to a distributed relational database

What makes a distributed relational database application distributed is its ability to connect to a relational database on another system.

There are two types of CONNECT statements with the same syntax but different semantics:
  • CONNECT (Type 1) is used for remote unit of work.
  • CONNECT (Type 2) is used for distributed unit of work.

For embedded SQL applications, the RDBCNNMTH parameter on the CRTSQLxxx commands determines the type of CONNECT. CLI and Java™ applications always use distributed unit of work because of the nature of the language.