Introduction to CA IDMS Data Manipulation Language › Programming in the CA IDMS Environment › LRF DML

LRF DML

LRF (Logical Record Facility) statements allow you to access fields from multiple database records as if they are data fields in a single record. You specify selection criteria (using the WHERE clause) to access only the logical records you need.

Using LRF, you do not have to be familiar with database structure and your programs do not have to include database navigation logic.

This manual describes these LRF DML statements:

• ERASE deletes a logical record as specified in the path definition
• MODIFY modifies a logical record as specified in the path definition
• OBTAIN retrieves a logical record as specified in the path definition
• STORE stores a logical record as specified in the path definition

Note: You must use the 48-character set for PL/I programs containing LRF DML (see PL/I Compiler Option Usage).

Note:

• For more information on path definition, see the CA IDMS Navigational DML Programming Guide.
• For more information on the Logical Record Facility, see the CA IDMS Logical Record Facility Guide.

Example of LRF DML Statements

The following figure illustrates the EMP_JOB_LR record. This record is a logical LRF record that contains the EMPLOYEE record, OFFICE record, and JOB record.