A remote server with server class HANAODBC is an SAP HANA database server.
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';
When you execute a CREATE TABLE statement, SAP Sybase IQ automatically converts the data types to the corresponding SAP HANA data types. The following table describes the SAP Sybase IQ to SAP HANA data type conversions.
SAP Sybase IQ 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) |