CICS VSAM Transparency for z/OS, Version 1.2


Runtime data conversion errors

If an invalid data value is provided by an application program for a key or alternate index field, no record is retrieved and an appropriate return code or CICS® RESP code is set.

For example, assume that you have a file with a packed decimal key field or subfield which is mapped to a decimal column in DB2®. If your application program issues a START BROWSE with a key of LOW-VALUES, an error is returned. DB2 returns SQL code -310 for an invalid decimal value and -181 for an invalid DATE or TIMESTAMP value. Invalid zoned decimal key data may result in an S0C7 data exception abend.

This is another scenario where an FBE may be desirable.



Concept topic


Last updated: December 6, 2013 20:45:4

Concept Concept

Feedback


Timestamp icon Last updated: Friday, 6 December 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///topics/cvtdecruntimedcerror.html