Certain data conversion problems can be avoided by analyzing the data unloaded from VSAM before attempting to convert it with the VIDLOAD utility program.
If you add the DD statement VIDS0C7 to the JCL for the VIDLOAD utility program, CICS® VT reads the data set produced by the VIDUNLOD utility program and identifies every field that would otherwise cause an S0C7 abend during data conversion. This is shown in the following JCL:
//VIDLOAD EXEC PGM=VIDLOAD,PARM='dimname'
//STEPLIB DD DSN=appl.DRIVERS.LOAD,DISP=SHR
// DD DSN=VID.SVIDLODE,DISP=SHR
//SYSPRINT DD SYSOUT=*
//LOADIN DD DSN=vsam.unload,DISP=SHR
//LOADOUT DD DUMMY
//VIDS0C7 DD SYSOUT=*
CICS VT reads the entire file specified by the LOADIN DD statement and invalid records are written to the DD VIDS0C7. An example of the output produced by CICS VT follows:
VID DATA EXCEPTION REPORT
RECORD 0000000002 OFFSET 0029 DATASET VIDKSDS
FIELD NAME VIDF004 LENGTH 0004 VALUE xxxx
RECORD 0000000217 OFFSET 0039 DATASET VIDKSDS
FIELD NAME VIDF007 LENGTH 0005 VALUE yyyyy
These errors refer to the CICS VT sample file VIDKSDS. The fields in error, VIDF004 and VIDF007, are packed decimal fields, and the field values shown are invalid for this data type. If your DB2® table includes decimal or integer column types, you should run the VIDLOAD utility with the VIDS0C7 DD statement before attempting to convert the VSAM data.