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.