Multiple choice technology mainframe

Identify the correct syntax.

  1. SELECT FROM(IN) TO(OUT1) ON(5,4,ZD) FIRSTDUP USING(CTL1)

  2. SELECT FROMFILE(IN) TOFILE(OUT1) ON(5,4,ZD) FIRSTDUP USING(CTL1)

  3. SELECT file1(IN) file2(OUT1) ON(5,4,ZD) FIRSTDUP USING(CTL1)

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The correct SELECT syntax is SELECT FROM(IN) TO(OUT1) ON(5,4,ZD) FIRSTDUP USING(CTL1). FROM/TO use DDnames, ON specifies position 5, length 4, format ZD (zoned decimal), FIRSTDUP selects first duplicate, USING references control cards.

Keep practicing — related questions