ODBC Extension
The ODBC extension works with the following data types:
- SQL_SS_XML
- SQL_GUID
- SQL_BIT
- SQL_TINYINT
- SQL_BIGINT
- SQL_LONGVARBINARY
- SQL_VARBINARY
- SQL_BINARY
- SQL_LONGVARCHAR
- SQL_CHAR
- SQL_NUMERIC
- SQL_DECIMAL
- SQL_INTEGER
- SQL_SMALLINT
- SQL_FLOAT
- SQL_REAL
- SQL_DOUBLE
- SQL_DATE
- SQL_TIME
- SQL_TIMESTAMP
- SQL_VARCHAR
- SQL_TYPE_DATE
- SQL_TYPE_TIME
- SQL_TYPE_TIMESTAMP
Oracle Extension
The Oracle Extension works with the following Oracle Built-in data types:
- VARCHAR2
- NUMBER
- FLOAT
- LONG
- DATE
- TIMESTAMP
- INTERVAL YEAR TO MONTH
- INTERVAL DAY TO SECOND
- RAW
- LONG RAW
- CHAR
- CLOB
- BLOB
- BFILE
The Oracle Extension also works with the following Oracle-supplied type: XMLType.
DB2 for z/OS Environment Data Type
Data Express for z/OS works with the following DB2 data types:
- CHAR
- VARCHAR
- GRAPHIC (Processed as char)
- VARGRAPHIC (Processed as Varchar)
- TIME
- TIMESTAMP
- DATE
- SMALL INTEGER
- INTEGER
- BIGINT
- DECIMAL
- NUMERIC
- REAL FLOAT (Supported only for Loading process)
- DOUBLE FLOAT (Supported only for Loading process)
- DOUBLE PRECISION FLOAT (Supported only for Loading process)
- DECFLOAT (Supported only for Loading process)
- ROWID
- LONGVARCHAR
- LONGVARGRAPHIC
- BINARY
- VARBINARY
z/OS also works with the following Large Object data type:
COBOL & PL/I for z/OS Environment Data Type
Data Express for z/OS works with the following Cobol & PL/I data types:
- CHAR PIC X(n)
- BINARY PIC 9(n) COMP-4
- PACKED PIC S9(p-s)V9(s) COMP-3
- ZONED PIC S9(p-s)V9(s)
- EDITED Use of edit char, e.g. PIC ZZ99
ADABAS for z/OS Environment Data Type
Data Express for z/OS works with the following ADABAS data types:
- ALPHANUMERIC
- BINARY
- F LOATING POINT
- PACKED DECIMAL
- UNPACKED DECIMAL(ZONED)