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:
CREATE EXISTING TABLE employees 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.
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 |
| TIMESTAMP | date |
| SMALLDATETIME | date |
| DATETIME | 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 |
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |