Supported Data Types

DB2 for z/OS Environment Data Type

Data Manager 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:

• CLOB
• DBCLOB
• BLOB
• XML

COBOL & PL/I for z/OS Environment Data Type

Data Manager 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 Manager for z/OS works with the following ADABAS data types:

• ALPHANUMERIC
• BINARY
• F LOATING POINT
• PACKED DECIMAL
• UNPACKED DECIMAL(ZONED)