Data Type Mapping

Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.
Database Connectors for Oracle supports the following data types.
COBOL Oracle
PIC X CHAR
PIC X(n) CHAR(n)
PIC X(n) VARCHAR2 (VAR_LENGTH directive is required)
PIC X(n) RAW(n)
PIC 9(n) NUMBER(n)
PIC 9(n) RAW(n)
PIC 9(n)V9(m) NUMBER(n+m, m)
example: PIC999V99     NUMBER(5,2)
Oracle COBOL
CHAR PIC X
CHAR(n) PIC X(n)
VARCHAR2 PIC X(n) (VAR_LENGTH directive is required)
DATE PIC 9(6) or PIC 9(8)
NUMBER(n) PIC 9(n)
NUMBER(n, m) PIC 9(n-m)V9(m)
RAW(n) PIC X(n) or PIC 9(n) (BINARY directive is required)
example: NUMBER(4,3)     PIC9V999

Internally, Database Connectors for Oracle uses VARCHAR to prevent key fields that are all spaces from being converted to null.

These Oracle data types are not currently supported:

  • LONG
  • LONG RAW