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.
Field type | DB2 column type |
---|---|
C | CHAR, VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, DATE, TIME, and TIMESTAMP |
![]() ![]() |
![]() ![]() |
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.