Adaptive Server to DB2 Datatypes

Lists class-level translations from Adaptive Server datatypes to DB2 datatypes.

Adaptive Server Datatype	DB2 Datatype
`bigdatetime`	`TIMESTAMP`
`bigint`	`BIGINT`
`bigtime`	`TIMESTAMP`
`binary`	`CHAR FOR BIT DATA`
`bit`	`TINYINT`
`date`	`DATE` (UNIX and Windows only)
`datetime`	`TIMESTAMP`
`decimal`	`DECIMAL`
`int`	`NUMERIC`
`money`	`NUMERIC`
`numeric`	`NUMERIC`
`real`	`REAL` (UNIX and Windows only)
`smalldatetime`	`TIMESTAMP`
`smallint`	`NUMERIC`
`smallmoney`	`NUMERIC`
`time`	`TIME` (UNIX and Windows only)
`tinyint`	`NUMERIC`
`unsigned bigint`	`DECIMAL (20,0)`
`unsigned int`	`BIGINT`
`unsigned smallint`	`INTEGER`
`unsigned tinyint`	`SMALLINT`
`unitext`	`DBCLOB`
`varbinary`	`VARCHAR FOR BIT DATA`

Parent topic: DB2 Datatypes

Created December 12, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com