Server class DB2ODBC

A remote server with server class DB2ODBC is an IBM DB2 database server.

Notes

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. SQL Anywhere 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';

Data type conversions: IBM DB2

When you execute a CREATE TABLE statement, SQL Anywhere automatically converts the data types to the corresponding IBM DB2 data types. The following table describes the SQL Anywhere to IBM DB2 data type conversions.

SQL Anywhere 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

Discuter à propos de cette page dans DocCommentXchange.