Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Server classes for remote data access » ODBC-based server classes


Server class oraodbc

A server with server class oraodbc is Oracle version 8.0 or later.

  • Sybase certifies the use of version 8.0.03 of Oracle's ODBC driver. Configure and test your ODBC configuration using the instructions for that product.

  • The following is an example of a CREATE EXISTING TABLE statement for an Oracle server named myora:

    AT 'myora.database.owner.employees';
  • As a result of Oracle ODBC driver restrictions, you cannot issue a CREATE EXISTING TABLE statement for system tables. A message returns stating that the table or columns cannot be found.

Data type conversions: Oracle

When you issue a CREATE TABLE statement, SQL Anywhere automatically converts the data types to the corresponding Oracle data types using the following data type conversions.

SQL Anywhere data type Oracle data type
BIT number(1,0)
TINYINT number(3,0)
SMALLINT number(5,0)
INT number(11,0)
BIGINT number(20,0)
DECIMAL(prec, scale) number(prec, scale)
NUMERIC(prec, scale) number(prec, scale)
FLOAT float
REAL real
SMALLMONEY numeric(13,4)
MONEY number(19,4)
DATE date
TIME date
CHAR(n) if (n > 255) long else varchar(n)
VARCHAR(n) if (n > 2000) long else varchar(n)
LONG VARCHAR long or clob
BINARY(n) if (n > 255) long raw else raw(n)
VARBINARY(n) if (n > 255) long raw else raw(n)
LONG BINARY long raw