Avoiding data translation errors

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   
Start of change //          DD DSN=VID.SVIDLODE,DISP=SHR      End of change
//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.


Information Information

Feedback


Timestamp icon Last updated: Monday, 10 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic/com.ibm.cics.vt.doc//topics/cvtug_avoiddata_transerror.html