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 change P and U End of change Start of change SMALLINT, INTEGER, BIGINT, DECIMAL, DATE, TIME, and TIMESTAMP End 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 Concept

Feedback


Timestamp icon Last updated: Monday, 10 February 2014


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