The following table lists CA IDMS/DB DML statements by function.
Note: You can use CA IDMS/DB statements in a DC/UCF system environment. However, you cannot use DC/UCF system statements in the CA IDMS/DB environment.
|
Function |
DML Statement |
Description |
|---|---|---|
|
Control |
BIND RUN-UNIT |
Signs on the application program to the DBMS |
|
|
BIND RECORD |
Establishes addressability in variable storage for one or more records included in the program's subschema |
|
|
BIND PROCEDURE |
Establishes communication between the application program and a DBA-defined database procedure |
|
|
READY |
Prepares database areas for processing |
|
|
FINISH |
Commits changes made to the database through an individual run unit or through all database sessions associated with a task |
|
|
IF |
Evaluates the presence of member records in a set or a record's membership status and specifies action based on the outcome |
|
|
COMMIT |
Commits changes made to the database through an individual run unit or through all database sessions associated with a task |
|
|
ROLLBACK |
Rolls back uncommitted changes made to the database through an individual run unit or through all database sessions associated with a task |
|
|
KEEP CURRENT |
Places an explicit shared or exclusive lock on a record that is current of run unit, record, set, or area |
|
Retrieval |
FIND/OBTAIN DBKEY |
Accesses a record using a db-key previously saved by the program |
|
|
FIND/OBTAIN CURRENT |
Accesses a record using previously established currencies |
|
|
FIND/OBTAIN WITHIN SET/AREA |
Accesses a record based on its logical location within a set or its physical location within an area |
|
|
FIND/OBTAIN OWNER |
Accesses the owner record of a set occurrence |
|
|
FIND/OBTAIN CALC/DUPLICATE |
Accesses a record using its CALC-key value |
|
|
FIND/OBTAIN USING SORT KEY |
Accesses a record in a sorted set using its sort-key value |
|
|
GET |
Moves all data associated with a previously located record into program variable storage |
|
|
RETURN |
Retrieves the database and symbolic keys of an indexed record entry |
|
Modification |
STORE |
Adds a new record to the database |
|
|
MODIFY |
Changes the contents of an existing record |
|
|
CONNECT |
Links a record to a set |
|
|
DISCONNECT |
Removes a member record from a set |
|
|
ERASE |
Deletes a record from the database |
|
Accept |
ACCEPT DBKEY FROM CURRENCY |
Saves the db-key and optionally the page information of the current record of run unit, record type, set, or area |
|
|
ACCEPT DBKEY RELATIVE TO CURRENCY |
Saves the db-key and optionally the page information of the next, prior, or owner record relative to the current record of a set |
|
|
ACCEPT IDMS STATISTICS |
Returns system runtime statistics to the program |
|
|
ACCEPT BIND RECORD |
Returns a record's bind address to the program |
|
|
ACCEPT PAGE_INFO |
Returns page information for a given record to the program |
|
|
ACCEPT PROCEDURE |
Returns information from the application program information block associated with a database procedure to the program |
|
Logical Record Facility |
ERASE |
Deletes a logical record |
|
|
MODIFY |
Modifies a logical record |
|
|
OBTAIN |
Accesses a logical record |
|
|
STORE |
Stores a logical record |
|
Recovery |
COMMIT |
Commits changes made to the database through an individual run unit or through all database sessions associated with a task |
|
|
FINISH |
Commits changes made to the database through an individual run unit or through all database sessions associated with a task |
|
|
ROLLBACK |
Rolls back uncommitted changes made to the database through an individual run unit or through all database sessions associated with a task |
|
|
WRITE JOURNAL |
Writes user-defined records to the journal file |
|
Copyright © 2014 CA.
All rights reserved.
|
|