Previous Topic: Step 2— Select what records you wantNext Topic: Step 4— Retrieve your data


Step 3— Select your columns

Select EMP-ID-0415 and EMP-LAST-NAME-0415 from the EMPLOYEE record. Select OFFICE-CODE-0450 and OFFICE-CITY-0450 from the OFFICE record. Press [PF8] to view more pages of the screen.

CA OLQ Release nn.n *** Column Select *** -> Page 1 of 3 124000 Select columns, specify selection criteria and press ENTER key Columns Currently Selected: 0 Selection Criteria Distinct N Y/N _ EMPLOYEE x 02 EMP-ID-0415 * _ 02 EMP-NAME-0415 _ 03 EMP-FIRST-NAME-0415 * x 03 EMP-LAST-NAME-0415 * _ 02 EMP-ADDRESS-0415 _ 03 EMP-STREET-0415 _ 03 EMP-CITY-0415 _ 03 EMP-STATE-0415 _ 03 EMP-ZIP-0415 _ 04 EMP-ZIP-FIRST-FIVE-0415 _ 04 EMP-ZIP-LAST-FOUR-0415 _ 02 EMP-PHONE-0415 _ 02 STATUS-0415 Additional selection criteria: 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD PA2=REFRESH