Logical records allow users to access database records without knowing the structure of the database. A logical record is a concatenation of two or more database records. Typically, the PATH parameter specifies one logical record; however, a PATH parameter may also specify a string of database records followed by the logical record, as shown in the examples below:
PATHYZ EMP-JOB-LR PATHCF DEPARTMENT EMP-JOB-LR
A logical record PATH parameter can specify a null path identifier and a WHERE clause. CA Culprit returns the null path ID to the PATH-ID field if it was not able to retrieve an occurrence of the logical record. The WHERE clause allows CA Culprit to selectively retrieve logical record occurrences; in the example shown below, the WHERE clause selects logical record occurrences that specify 5100 for the department id:
PATHDD EMP-JOB-LR WHERE DEPT-ID-0410 EQ '5100'
|
Copyright © 2014 CA.
All rights reserved.
|
|