D Back-end Adapter Data Type Support

The OracleAS CDC Adapter for DB2 supports several data types that are used when defining metadata in Oracle Studio. The data types are mapped from the COBOL data types during the import procedure.

Note:

The mapping of data types between the OracleAS CDC Adapter for DB2 and Oracle Application Server is performed internally by Oracle Connect.

Data Type Mapping

The COBOL data type COMP, in the table is an abbreviation for, and synonymous with, COMPUTATIONAL. Square brackets ([ ]) denote optional qualifiers for some COBOL compilers, which may not be allowed for other COBOL compilers.

Table D-1 Data Type Mapping: COBOL and Oracle Connect Back-end Adapter

COBOL Data Type	Oracle Connect Data Type
`BINARY` (with fractional data)	`string`
`BINARY` (without fractional data)	`int`
`COMP` (with fractional data)	`string`
`COMP` (without fractional data)	`int`
`COMP-2`	`double`
`COMP-3`	`string`
`COMP-4` (with fractional data)	`string`
`COMP-4` (without fractional data)	`int`
`COMP-5` (with fractional data)	`string`
`COMP-5` (without fractional data)	`int`
`COMP-X` (with fractional data)	`string`
`COMP-X` (without fractional data)	`int`
`INDEX`	`int`
`[SIGN [IS]] LEADING`	`string`
`[SIGN [IS]] LEADING SEPARATE [CHARACTER]`	`string`
`NATIVE-2`	`int`
`NATIVE-4`	`int`
`NATIVE-8`	`string`
`PACKED-DECIMAL`	`string`
`POINTER`	`int`
`[SIGN [IS]] TRAILING`	`string`
`[SIGN [IS]] TRAILING SEPARATE [CHARACTER]`	`string`