DDM commands for data operations with the IMS support for DRDA

Use the distributed database management (DDM) commands provided by the IMS support for DRDA for singleton and batch data operations.

Before accessing the database, you need to first establish a database connection by issuing an ACCRDB command from your DRDA client application and successfully receive an ACCRDBRM data object back from the DRDA target server.

After the connection is established, you can issue DDM commands to access data from your DRDA client application.
  • To retrieve data, issue an OPNQRY command.
  • To insert, update, or delete data, issue an EXCSQLIMM command.
Data operations can be in singleton or batch operations. Specify the type of data operation by setting the Byte String Data Representation (BYTSTRDR) parameter in the DLIFUNC command object that is chained to the DDM command.

The following table shows the DDM commands that the DRDA client issues for data operations with the IMS support for DRDA.

Table 1. DDM commands for data operations with the IMS support for DRDA
Data operation DDM command BYTSTRDR parameter value for DLIFUNC command object
Insert data EXCSQLIMM ISRT
Retrieve data - DL/I Get Hold Unique OPNQRY GHU
Retrieve data - DL/I Get Unique OPNQRY GU
Retrieve data - DL/I Get Hold Next OPNQRY GHN
Retrieve data - DL/I Get Next OPNQRY GN
Retrieve data - DL/I Get Hold Next Within Parent OPNQRY GHNP
Retrieve data - DL/I Get Next Within Parent OPNQRY GNP
Update data EXCSQLIMM REPL
Delete data EXCSQLIMM DLET

The following table shows the DDM commands that the DRDA client issues for batch data operations with the IMS support for DRDA.

Table 2. DDM commands for batch data operations with the IMS support for DRDA
Batch data operation DDM command BYTSTRDR parameter value for DLIFUNC command object
Retrieve data OPNQRY RETRIEVE
Update data EXCSQLIMM UPDATE
Delete data EXCSQLIMM DELETE