WHERE-PAR

It is possible to specify one or more formal parameters when using the WITH and FORALL statements to retrieve specific data.

Example

FORALL Person IN XXX.Persons
DO
    WITH Address IN Person.Address_of_person WHERE 
    PAR ( 1 ) = "233 M2" 
    PAR ( 2 ) = 12 	     
        DO 
             ...
        OD 
OD

Result: For persons that have postcode "233 M2" and house number 12, the address is stated.

This could also be done with a PATH statement; however, with the PATH-PAR statement all the formal parameter positions must be defined to directly address an entry. The statement allows also the following example.

Example

This example shows that the statement WHERE-PAR allows that not all formal parameters are passed to the entry. If not all formal parameters are passed the result will be more than one returned record.

FORALL Person IN XXX.Persons
DO
    WITH Address IN Person.Address_of_person WHERE 
    PAR ( 1 ) = "233 M2"    
        DO 				
             ...
        OD 
OD

Result: for all persons that have zipcode 233 M2 the address is stated.