The chart below identifies source data types that are:
- supported
- * - not supported
- ** - supported for straight replication between different instances of the same DATASTORE type
| Generic Data Type | DB2 z/OS | COBOL (IMS/VSAM) |
|---|---|---|
| Character | DB2 z/OS | COBOL (IMS/VSAM) |
| char | CHAR (n) | PIC X(n) |
| nchar | ||
| nvarchar | ||
| varchar | VARCHAR(n) | |
| LONG VARCHAR(n) | ||
| CLOB(n) | ||
| DBCLOB(n) | ||
| Date and Time | DB2 z/OS | COBOL (IMS/VSAM) |
| datetime | ||
| smalldatetime | ||
| timestamp | TIMESTAMP | |
| DATE | ||
| TIME | ||
| Numeric | DB2 z/OS | COBOL (IMS/VSAM) |
| bigint | BIGINT | PIC s9(18) |
| bit | ||
| decimal | DECIMAL / NUMERIC | PIC s9(n)V9(n) |
| int | INT / INTEGER | PIC s9(9) |
| money | ||
| numeric | ||
| smallint | SMALLINT | PIC s9(4) |
| smallmoney | ||
| tinyint | ||
| FLOAT** | ||
| REAL** | ||
| DECFLOAT(16)** | ||
| DECFLOAT(34)** | ||
| DOUBLE** | ||
| Binary | DB2 z/OS | COBOL (IMS/VSAM) |
| binary | BINARY(n) | |
| varbinary | VARBINARY(n) | |
| Graphic | DB2 z/OS | COBOL (IMS/VSAM) |
| GRAPHIC(n)* | ||
| VARGRAPHIC(n)* | ||
| LONG VARGRAPHIC* | ||
| LOBs | DB2 z/OS | COBOL (IMS/VSAM) |
| BLOB(n)* | ||
| CLOB(n)* | ||
| DBCLOB(n)* | ||
| XML* | ||
| Other | DB2 z/OS | COBOL (IMS/VSAM) |
| ROWID* |