A server with server class oraodbc is Oracle version 8.0 or later.
NotesSybase certifies the use of the Oracle version 8.0.03 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 execute a CREATE EXISTING TABLE statement for system tables. A message returns stating that the table or columns cannot be found.
Data type conversions: OracleWhen you execute 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.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |