ZAP is a
Branch Instruction
Arithmetic Instruction
Decimal Instruction
Assembler Directive
Decimal instructions works with _____ operands
Register Operands
Storage Operands
Implied Operands
Immediate Operands
which function allows to select n records after removing duplicates
DUPLICATE (n)
REMOVDUP (n)
FIRSTDUP(n)
NONE OF THE ABOVE
ICETOOL's ____ operator allows you to display counts in reports.
BCOUNT('string')
COUNT('string')
CCOUNT('string')
DCOUNT('string')
FINDREP allows you to do various types of find and replace operations on your records.
True
False
FINDREP cannot be specified with BUILD or OVERLAY in an IFTHEN clause.
DATASORT allows you to sort data records between header records and trailer records.
Identify the correct syntax.
SELECT FROM(IN) TO(OUT1) ON(5,4,ZD) FIRSTDUP USING(CTL1)
SELECT FROMFILE(IN) TOFILE(OUT1) ON(5,4,ZD) FIRSTDUP USING(CTL1)
SELECT file1(IN) file2(OUT1) ON(5,4,ZD) FIRSTDUP USING(CTL1)
None of the above
Identify the correct sysntax:
None of the Below
SUBSET IN1 TO OUT1
SUBSET FROM(IN1) OF(OUT1)
SUBSET FROM(IN1) TO(OUT1)
Which one is not a Non Numeric picture clause?
A
B
V
X