Defining a Database Using Non-SQL › Defining a Subschema › PATH-GROUP Statements

PATH-GROUP Statements

PATH-GROUP statements define paths for a specific logical record. At runtime, LRF services program requests by following one of the paths to access the logical record.

For each logical record, at least one path group, and at most four (one for each DML verb that can be used to access the logical record), must be defined. A path group can contain any number of paths. Which path LRF uses at runtime is determined by selection criteria, both in the path group and in the program requesting LRF services.

Note: For more information about logical records and path groups, see the CA IDMS Logical Record Facility Guide document.

The subschema compiler applies PATH-GROUP statements to the current subschema.

Procedure

1. Name the type of path group
2. Add appropriate DML statements

Example

add path-group name is store emp-pers-data
  select
    find first department
       where calckey eq dept-id-0410 of lr
       on 0326 return no-dept
       on 0000 next
    find first office
       where calckey eq office-code-0450 of lr
       on 0326 return no-office
       on 0000 next
    find first employee
       where calckey eq emp-id-0415 of lr
       on 0000 return emp-exists
       on 0326 next
    store employee
       on 0000 next