ICETOOL VERIFY Operator

VERIFY operator is used to verify the existance of numeric data in specified columns of all the records. It examines up to 10 fields and displays message for each invalid value found for each field.

Syntax -

VERIFY 
   FROM(indd) 
   ON(p,l,f) 
  [NOSIGN]
  [LIMIT(n)]
  [VSAMTYPE(x)]

Required Operands

  • FROM - specifies ddname of the input file. It is mandatory when FROM operand is coded.
  • ON (p,l,f) - specifies the field(s) used for validation.
    • p - gives the starting position of field.
    • l - gives the length of the field. The field should not be beyond position 32752 or the end of the record.
    • f - gives the format of the data. The valid formats are PD(Signed Packed decimal - 1 to 16 bytes) and ZD (Signed Zoned decimal - 1 to 31 bytes).

Optional Operands

  • VSAMTYPE - specifies the record format for a VSAM input file. It should be either F (fixed-length) or V (variable-length) record processing.
  • NOSIGN - specifies the sign of the decimal values that is not to be validated.
  • LIMIT - specifies the limit for the number of invalid decimal values. It overrides the default of 200. If 'n' invalid decimal values are found, ICETOOL terminates the VERIFY operation.

Example -

Scenario - Verifing the existance of non-numeric values between the 70 to 79 columns.

INPUT1 - MATEPK.INPUT.PSFILE

----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
001  PAWAN         MAINFRAME           JPM       AP        IN        0000100000
002  SRINIVAS      TESTING             ORACLE    TG        IN        0000095000
003  SRIDHAR       SAS                 CG        OR        US        0000080000
004  VENKATESH     ABAP                CSC       CA        IN        0000053000
005  RAVI          HADOOP              CTS       FL        US        0000072000
006  PRASAD        HR                  INFOSYS   MI        US        0000066000
007  RAJA          TESTING             IBM       CA        US        0000047000

JCL -

Full Example    
----+----1----+----2----+----3----+----4----+----5----+
...
//STEP01   EXEC PGM=ICETOOL
//INDD     DD DSN=MATEPK.INPUT.PSFILE6,DISP=SHR
//TOOLIN   DD *
  VERIFY FROM(INDD) ON(70,10,ZD)
/*
...

TOOLMSG (SDSF SPOOL) - Verify TOOLMSG for the return code of the submitted job.

VERIFY TOOLMSG