Database management call summary
The following table shows the parameters that are valid for each database management call.
Optional parameters are enclosed in brackets ([ ]).
Restriction: Language-dependent parameters are not shown here. The variable parmcount is required for all PLITDLI calls. Either parmcount or VL is required for assembler language calls. Parmcount is optional in COBOL, C, and Pascal programs.
Related reading: For more information on language-dependent application elements, see the topic "Defining Application Program Elements" in IMS Version 15.3 Application Programming.
| Function Code | Meaning and Use | Options | Parameters | Valid for |
|---|---|---|---|---|
| CIMS | Initializes and terminates the ODBA interface in a z/OS® application region. | aib | DB/DC, DBCTL, ODBA | |
| CLSE | Close | Closes a GSAM database explicitly | function, gsam pcb or aib | DB/DC, DBCTL, DB batch, ODBA |
| DEQb | Dequeue | Releases segments reserved by Q command code | function, i/o pcb (full function only), or aib, i/o area (full function only) | DB batch, BMP, MPP, IFP, DBCTL, ODBA |
| DLET | Delete | Removes a segment and its dependents from the database | function, db pcb or aib, i/o area, [ssa] | DB/DC, DBCTL, DB batch, ODBA |
| FLDb | Field | Accesses a field within a segment | function, db pcb or aib, i/o area, rootssa | DB/DC, ODBA |
| GHNb | Get Hold Next | Retrieves subsequent message segments | function, db pcb or aib, i/o area, [ssa] | DB/DC, DBCTL, DB batch, ODBA |
| GHNP | Get Hold Next in Parent | Retrieves dependents sequentially | function, db pcb or aib, i/o area, [ssa] | DB/DC, DBCTL, DB batch, ODBA |
| GHUb | Get Hold Unique | Retrieves segments and establishes a starting position in the database | function, db pcb or aib, i/o area, [ssa] | DB/DC, DBCTL, DB batch, ODBA |
| GNbb | Get Next | Retrieves subsequent message segments | function, db pcb or aib, i/o area, [ssa or rsa] | DB/DC, DBCTL, DB batch, ODBA |
| GNPb | Get Next in Parent | Retrieves dependents sequentially | function, db pcb or aib, i/o area, [ssa] | DB/DC, DBCTL, DB batch, ODBA |
| GUbb | Get Unique | Retrieves segments and establishes a starting position in the database | function, db pcb or aib, i/o area, [ssa or rsa] | DB/DC, DBCTL, DB batch, ODBA |
| GUR | Get Unique Record | Retrieves a complete record from the IMS catalog in XML format | function, aib, i/o area, [ssa] | DB/DC, DBCTL, DB batch, ODBA |
| ISRT | Insert | Loads and adds one or more segments to the database | function, db pcb or aib, i/o area, [ssa or rsa] | DB/DC, DCCTL, DB batch, ODBA |
| OPEN | Open | Opens a GSAM database explicitly | function, gsam pcb or aib, [i/o area] | DB/DC, DBCTL, DB batch, ODBA |
| POSb | Position | Retrieves the location of a specific dependent or last-inserted sequential dependent segment | function, db pcb or aib, i/o area, [ssa] | DB/DC, DBCTL, DB batch, ODBA |
| REPL | Replace | Changes values of one or more fields in a segment | function, db pcb or aib, i/o area, [ssa] | DB/DC, DBCTL, DB batch, ODBA |
| RLSE | Release Locks | Releases all locks held for unmodified data | function, db pcb | DB/DC, DBCTL, DB batch, ODBA |