When you use a CREATE EXISTING statement to create a proxy table to an existing Oracle table, IQ converts the Oracle data types to corresponding IQ data types.
Oracle data type |
IQ data type |
|---|---|
BFILE |
LONG BINARY |
BLOB |
LONG BINARY |
CHAR(n) |
CHAR(n) |
CLOB |
LONG VARCHAR |
DATE |
TIMESTAMP |
DEC(prec, scale) |
NUMERIC(prec, scale) |
DECIMAL(prec, scale) |
NUMERIC(prec, scale) |
DOUBLE PRECISION |
DOUBLE |
FLOAT |
DOUBLE |
INT |
NUMERIC(38,0) |
INTEGER |
NUMERIC(38,0) |
NCHAR(n) |
NCHAR(n) |
NCLOB |
LONG NVARCHAR |
NUMBER(prec, scale) |
NUMERIC(prec, scale) |
NUMERIC(prec, scale) |
NUMERIC(prec, scale) |
NVARCHAR2(n) |
VARCHAR(n) |
RAW(n) |
VARBINARY(n) |
REAL |
DOUBLE |
SMALLINT |
NUMERIC(38,0) |
TIMESTAMP |
TIMESTAMP |
VARCHAR2(n) |
VARCHAR(n) |
Sybase IQ lets you map proxy tables to Oracle views. Because Oracle identifiers always appear in upper case letters, you must use upper-case letters to create or refer to any proxy table that you map to an Oracle view.