Rules and restrictions when using DRDA

There are Distributed Relational Database Architecture™ (DRDA) limitations when using IBM® i Access Client Solutions database servers.

DRDA is an architecture that supports access between relational databases. For more information on the DRDA architecture, see the Distributed database programming topic collection.

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

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 a IBM i connection.
Commit level *NONE Not supported
Commit level *CHANGE Only supported if the target RDB is a IBM i target. All other RDBs require a *CS or *ALL commit level.