VERIFY Operator
Verify the existance of numeric data (VERIFY Operator) Example
Scenario -Verifing the numeric value in the specified columns in all the records. In this example, we are trying to verify 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 -
----+----1----+----2----+----3----+----4----+----5----+
//MATEPKVR JOB (123),'MATEPK',CLASS=A,MSGCLASS=A,
// MSGLEVEL=(1,1),NOTIFY=&SYSUID
//*
//STEP01 EXEC PGM=ICETOOL
//INDD DD DSN=MATEPK.INPUT.PSFILE6,DISP=SHR
//TOOLIN DD *
VERIFY FROM(INDD) ON(70,10,ZD)
/*
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//
TOOLMSG (SDSF SPOOL) - Verify TOOLMSG for the return code of the submitted job.
Explaining Example -
- INDD - Specifies the ddname for input file.
- OUTDD - Specifies the ddname for output file.
- TOOLIN DD * - Specifies the ICETOOL statements for DFSORT.
- TOOLMSG - Specifies where to write the ICETOOL processing messages.
- DFSMSG - Specifies where to write the DFSORT processing messages.
- VERIFY FROM(INDD) ON(70,10,ZD) - Verifies and prints the invalid records having non-numeric values 70th position of length 10. In the above scenario, no invalid values found. So the VERIFY completed with RC 00.