CICS VSAM Transparency for z/OS, Version 1.2


Data conversion errors during initial data migration

CICS® VT assumes that all VSAM field values are valid.

For example, assume you have a packed decimal date field that you map to a DB2® date column. If the value in the VSAM file is not a valid date value on a WRITE/REWRITE call, DB2 disallows the SQL INSERT/UPDATE call. CICS VT interprets the SQL return code and sets an appropriate VSAM error code which is returned to your application program. The point at which the error occurs varies. It may be during the initial data migration or during initial DB2 load processing.

A common solution to data issues that arise during data migration is to code an FBE to perform data validation and correct invalid data values.



Concept topic


Last updated: May 25, 2012 20:46:6