By using logical records, the user can navigate a non-SQL defined database without knowing the structure of the database. A logical record is a concatenation of one or more database records that appears to the CA Culprit user as a single record. For example, the following report illustrates the subschema definition of the EMP-JOB-LR logical record, which includes the DEPARTMENT, EMPLOYEE, OFFICE, and JOB records shown in the figure earlier shown.
ADD LOGICAL RECORD NAME IS EMP-JOB-LR ELEMENTS ARE EMPLOYEE DEPARTMENT JOB OFFICE
Note: Logical records concatenate a string of database records. For example, EMP-JOB-LR contains four record types. Users do not need to know the set relationships between these record types to access information.
CA Culprit accesses logical records as they are encountered in the database. Users can specify logical record key values to selectively retrieve logical records. A logical record key is any logical record field.
Note: For more information about creating and using logical records, see the CA IDMS Logical Record Facility Guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|