B VSAM Back-end Adapter Data Type Support

OracleAS Adapter for VSAM supports a number of 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 OracleAS Adapter for VSAM 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 B-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`