Multiple choice technology mainframe

An i/p file PRODUCTS contains the records in the following sequence with the fields as SEQ #, PRODUCT NAME, PRODUCT CODE: 0001 LUX 1111 0002 PAMOLIVE 2222 0003 LUX INTERNATIONAL 1111 0004 CINTHOL 3333 Which if the following sort statements would COPY only the LUX products to the o/p file?

  1. SORT FIELDS = COPY INCLUDE COND = (24,4,CH,EQ,'1111')

  2. SORT FIELDS = COPY OMIT COND = (24,4,CH,NE,'1111')

  3. SORT FIELDS = COPY INCLUDE COND = (6,3,CH,EQ,'LUX')

  4. All of the above

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

All three options successfully filter the input. Option A includes records with code '1111', Option B omits records that do not have code '1111', and Option C includes records containing 'LUX' in the name field.