Physical and Logical Files: QDDSSRC



Logical File with Key Last Name and First Name, Selecting Only Customers in Texas that are active(File Name is SMP05)

A* NOTE THAT RECORD NAME AGREES WITH PHYSICAL FILE
A          R SMREC                  PFILE(SMP)               
A          K SMLNME                                           
A          K SMFNME
A* Select only records with state = "TX" and Status = "A"
A          S SMST                   COMP(EQ 'TX')
A            SMSTS                  COMP(EQ 'A')


Back to Source Code Page   |   Basic 400 Skills   |   Main Page