Objective
Our next report selects employees earning $15,000 or less and those earning between $35,000 and $50,000.
Parameters
SEL SALARY EQ (35000 TO 50000) specifies the first selection criteria.
OR relates the first test to the to the second by allowing selection of a record that meets only one of the specified conditions.
SALARY LE 15000 specifies the alternative record selection criteria.
The following BYPASS parameter achieves the same results:
Parameters
BYP SALARY EQ (15000.01 TO 34999.99) specifies the first record bypass criteria.
OR relates the first test to the second by allowing bypass of a record that meets only one of the specified conditions.
SALARY GT 50000 specifies the alternative record bypass criteria.
Complete Code
col. 2 ▼ IN 200 F 400 PS(TAPE) REC EMPLOYEE 5 25 REC LAST-NAME 15 15 REC SALARY 160 5 3 DP=2 SEL SALARY EQ (35000 TO 50000) OR SALARY LE 15000 013 EMPLOYEE SALARY LISTING 01SORT LAST-NAME 0151*010 EMPLOYEE HH 'EMPLOYEE' 0151*020 SALARY SZ=10 HH 'SALARY'
Result
REPORT NO. 01 EMPLOYEE SALARY LISTING mm/dd/yy PAGE 1 EMPLOYEE SALARY HARRY ARM 46,000.00 JUNE BLOOMER 15,000.00 CHARLES BOWER 38,500.00 C. BREEZE 38,000.00 TERRY CLOTH 38,000.00 CAROLYN CROW 37,500.00 PHINEAS FINN 45,000.00 TOM FITZHUGH 13,000.00 GEORGE FONRAD 14,750.00 ROBIN GARDNER 14,000.00 EDWARD HUTTON 44,000.00 JULIE JENSEN 37,000.00 CYNTHIA JOHNSON 13,500.00 MARIANNE KIMBALL 45,000.00 DORIS KING 14,500.00 TERENCE KLWELLEN 43,000.00 SANDY KRAAMER 14,000.00 LARRY LITERATA 37,500.00 RICHARD MUNYON 36,000.00 BRIAN NICEMAN 14,000.00 KATHERINE O'HEARN 42,500.00 MADELINE ORGRATZI 39,000.00 LAURA PENMAN 39,000.00 NANCY TERNER 13,000.00 RICHARD WAGNER 47,000.00 BETSY ZEDI 37,000.00 815,750.00
|
Copyright © 2014 CA.
All rights reserved.
|
|