A remote server with server class DB2ODBC is an IBM DB2 database server.
Sybase certifies the use of IBM's DB2 Connect version 5, with fix pack WR09044. Configure and test your ODBC configuration using the instructions for that product. SAP Sybase IQ has no specific requirements for the configuration of IBM DB2 data sources.
The following is an example of a CREATE EXISTING TABLE statement for an IBM DB2 server with an ODBC data source named mydb2:
CREATE EXISTING TABLE ibmcol AT 'mydb2..sysibm.syscolumns';
When you execute a CREATE TABLE statement, SAP Sybase IQ automatically converts the data types to the corresponding IBM DB2 data types. The following table describes the SAP Sybase IQ to IBM DB2 data type conversions.
| SAP Sybase IQ data type | IBM DB2 default data type |
|---|---|
| BIT | smallint |
| VARBIT(n) | if (n <= 4000) varchar(n) for bit data else long varchar for bit data |
| LONG VARBIT | long varchar for bit data |
| TINYINT | smallint |
| SMALLINT | smallint |
| INTEGER | int |
| BIGINT | decimal(20,0) |
| UNSIGNED TINYINT | int |
| UNSIGNED SMALLINT | int |
| UNSIGNED INTEGER | decimal(11,0) |
| UNSIGNED BIGINT | decimal(20,0) |
| CHAR(n) | if (n < 255) char(n) else if (n <= 4000) varchar(n) else long varchar |
| VARCHAR(n) | if (n <= 4000) varchar(n) else long varchar |
| LONG VARCHAR | long varchar |
| NCHAR(n) | Not supported |
| NVARCHAR(n) | Not supported |
| LONG NVARCHAR | Not supported |
| BINARY(n) | if (n <= 4000) varchar(n) for bit data else long varchar for bit data |
| VARBINARY(n) | if (n <= 4000) varchar(n) for bit data else long varchar for bit data |
| LONG BINARY | long varchar for bit data |
| DECIMAL(prec,scale) | decimal(prec,scale) |
| NUMERIC(prec,scale) | decimal(prec,scale) |
| SMALLMONEY | decimal(10,4) |
| MONEY | decimal(19,4) |
| REAL | real |
| DOUBLE | float |
| FLOAT(n) | float(n) |
| DATE | date |
| TIME | time |
| TIMESTAMP | timestamp |
| TIMESTAMP WITH TIMEZONE | varchar(254) |
| XML | long varchar for bit data |
| ST_GEOMETRY | long varchar for bit data |
| UNIQUEIDENTIFIER | varchar(16) for bit data |