Rules and restrictions when using DRDA

Distributed Relational Database Architecture™ (DRDA^®) is an architecture that allows access to other databases that support DRDA. For more information about DRDA, see Distributed database programming.

When using the database server as a gateway to other RDBs using DRDA, some limitations in functions must be followed.

The following table shows the functions that have limitations when you are connected to a remote system from the database server.

DRDA functional limits

Function	Limitation
Create package Clear package Delete package Describe parameter markers	Unsupported functions
Prepare	Enhanced prepare option not available when using DRDA.
Extended dynamic package support	When DRDA is used, statement names must be in the format of 'STMTxxxx', where xxxx is the section number. When DRDA is used, cursor names must be in the format of 'CRSRxxxx' or 'SCRSRxxxx', where xxxx is the section number.
Commit hold	Only valid if connected to an iSeries™ server
Commit level *NONE	Not supported
Commit level *CHANGE	Only supported if the target RDB is an iSeries. All other RDBs require a CS or ALL commit level.