Previous Topic: DML Statements Grouped by FunctionNext Topic: DML Statements (Data Communications)


DML Statements (Database)

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