Server class HANAODBC

A remote server with server class HANAODBC is an SAP HANA database server.

Notes

The following is an example of a CREATE EXISTING TABLE statement for an SAP HANA database server with an ODBC data source named mySAPHANA:

CREATE EXISTING TABLE hanatable
AT 'mySAPHANA..dbo.hanatable';

Data type conversions: SAP HANA

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

SQL Anywhere data type	SAP HANA default data type
BIT	TINYINT
VARBIT(n)	if (n <= 5000) VARBINARY(n) else BLOB
LONG VARBIT	BLOB
TINYINT	TINYINT
SMALLINT	SMALLINT
INTEGER	INTEGER
BIGINT	BIGINT
UNSIGNED TINYINT	TINYINT
UNSIGNED SMALLINT	INTEGER
UNSIGNED INTEGER	BIGINT
UNSIGNED BIGINT	DECIMAL(20,0)
CHAR(n)	if (n <= 5000) VARCHAR(n) else CLOB
VARCHAR(n	if (n <= 5000) VARCHAR(n) else CLOB
LONG VARCHAR	CLOB
NCHAR(n)	if (n <= 5000) NVARCHAR(n) else NCLOB
NVARCHAR(n)	if (n <= 5000) NVARCHAR(n) else NCLOB
LONG NVARCHAR	NCLOB
BINARY(n)	if (n <= 5000) VARBINARY(n) else BLOB
VARBINARY(n)	if (n <= 5000) VARBINARY(n) else BLOB
LONG BINARY	BLOB
DECIMAL(precision, scale)	DECIMAL(precision, scale)
NUMERIC(precision, scale)	DECIMAL(precision, scale)
SMALLMONEY	DECIMAL(13,4)
MONEY	DECIMAL(19,4)
REAL	REAL
DOUBLE	FLOAT
FLOAT(n)	FLOAT
DATE	DATE
TIME	TIME
TIMESTAMP	TIMESTAMP
TIMESTAMP WITH TIMEZONE	VARCHAR(254)
XML	BLOB
ST_GEOMETRY	BLOB
UNIQUEIDENTIFIER	VARBINARY(16)

Discuter à propos de cette page dans DocCommentXchange.