Tailoring the CA OLQ Environment for Ease of Use › Data Retrieval › Logical Records

Logical Records

With the Logical Record Facility (LRF), you can code logical records (combinations of database records) to decrease the number of calls made to CA IDMS/DB by a CA OLQ query.

With LRF you can eliminate the need for users to choose fields. You can code a logical record subschema and associate it with certain users. The subschema may contain only logical records and dictate what the user can retrieve.

Additionally, you can code many different paths to retrieve records from the database.

Note: For more information about the uses of LRF, see the CA IDMS Logical Record Facility Guide.

Using LRF

Example:

Without a logical record and path, a user would generate an employee salary report with:

select salary-amount-0420, emp-id-0415,
 emp-name-0415, dept-id-0410, dept-name-0410
 from emposition, employee, department
 where emp-emposition and dept-employee

With a logical record and path coded by the DBA, the user has two choices for generating the report:

• In command mode:

  select * from salary-report
  

  Where 'salary-report' is the name of the logical record, and the * (asterisk) stands for all fields within the logical record.

• In menu mode:

  Select the logical record from the Record Select screen.

Note: For instructions on coding retrieval paths using LRF, see the CA IDMS Logical Record Facility Guide.