IBM Db2 data type support
When a job runs, the stage maps InfoSphere® DataStage® data types to IBM® Db2® data types.
SQL type | Length | Scale | Extended | IBM Db2 Column Definition |
---|---|---|---|---|
BigInt | n/a | n/a | any | BIGINT |
Binary | n | n/a | n/a | CHAR(n) FOR BIT DATA1 |
Bit | n/a | n/a | n/a | SMALLINT |
Bit | n/a | n/a | n/a | not supported |
Char | n | n/a | blank | CHAR(n)1 |
Char | n | n/a | Unicode | GRAPHIC(n)1 |
Char | n | n/a | Unicode | CHAR(n) |
Date | n/a | n/a | n/a | DATE |
Decfloat | n/a | n/a | n/a | DECFLOAT |
Decimal | p | s | n/a | DECIMAL(p,s) |
Double | p | n/a | n/a | DOUBLE |
Double | p | n/a | n/a | FLOAT(p)1 |
Float | p | n/a | n/a | FLOAT |
Float | p | n/a | n/a | FLOAT(p)1 |
Graphic | n | n/a | n/a | GRAPHIC n) |
Integer | n/a | n/a | any | INTEGER |
LongNVarChar | n | n/a | n/a | DBCLOB |
LongNVarChar | n | n/a | n/a | LONG VARCHAR2 |
LongVarBinary | n | n/a | n/a | BLOB |
LongVarBinary | n | n/a | n/a | LONG VARCHAR FOR BIT DATA |
LongVarChar | n | n/a | blank | CLOB |
LongVarChar | n | n/a | blank | LONG VARCHAR3 |
LongVarChar | n | n/a | Unicode | DBCLOB |
LongVarChar | n | n/a | Unicode | LONG VARCHAR2 |
NChar | n | n/a | n/a | NCHAR(n) |
NVarChar | n | n/a | n/a | VARGRAPHIC(n)1 |
Numeric | p | s | n/a | DECIMAL(p,s) |
Real | n/a | n/a | n/a | REAL |
SmallInt | n/a | n/a | any | SMALLINT |
Time | n/a | s | any | TIME |
Timestamp | n/a | s | any | TIMESTAMP |
TinyInt | n/a | n/a | any | SMALLINT |
VarBinary | n | n/a | n/a | VARCHAR(n) FOR BIT DATA1 |
VarChar | n | n/a | blank | VARCHAR(n)1 |
VarChar | n | n/a | Unicode | VARGRAPHIC(n)1 |
VarChar | n | n/a | Unicode | (VARCHARn) |
Vargraphic | n | n/a | n/a | GRAPHIC n |
Table notes:
Table notes:
|