CICS VSAM Transparency for z/OS, Version 1.2


Built-in conversion routines

CICS® VT uses a subset of the built-in conversion routines, based on the combination of the field type specified in the mapping and the data type of the DB2® columns.

For example, in the field VIDF005 in Figure 1, the field type is "C" and the DB2 column type is SMALLINT. CICSVT uses the CHARSINT routine to convert the data from VSAM format, and SINTCHAR to convert from DB2 format toVSAM format. All the routines can be invoked by a user exit. Examples of calling the built-in routines in COBOL and assembler exits are covered later.

The following table defines the supported conversion combinations that can be achieved through mapping:
Field type DB2 column type
C CHAR, VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, DATE, TIME, and TIMESTAMP
Start of changeP and UEnd of change Start of changeSMALLINT, INTEGER, BIGINT, DECIMAL, DATE, TIME, and TIMESTAMPEnd of change
H and F DECIMAL

In the CICS VT mapping, field type "X" is treated the same as "C". VSAM fields with type "B", which is two fullwords, are assumed to contain numeric values that are only valid for the column type BIGINT.



Concept topic


Last updated: February 8, 2013 20:43:59