IBM Db2 data type support

When a job runs, the stage maps InfoSphere® DataStage® data types to IBM® Db2® data types.

Table 1. Mapping of 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:
  1. If the Length is left blank the DRS Connector stage assumes the length of 32.
Table notes:
  1. If the Length is left blank the Dynamic RDBMS stage assumes the length of 15. Depending on the specified Length p, IBM Db2 maps the FLOAT(p) data type to REAL or DOUBLE native data type.
  2. If the Length n is greater than 32700, the Dynamic RDBMS stage creates DBCLOB(n).
  3. If the Length n is greater than 32700, the Dynamic RDBMS stage creates CLOB(n).