Oracle-to-Adaptive Server Datatype Conversions for Non-Numeric Data with create proxy_table

Oracle datatypes are converted to the Adaptive Server datatypes when in passthrough mode.

Oracle Datatype

Adaptive Server Datatype

nchar(n) varchar(n)
float float
char(n) char(n)
varchar(n) varchar(n)
varchar2(n) varchar(n)
raw(n) binary(n)
clob text
nclob text
blob image
date datetime
bfile image
long text
long raw image
timestamp datetime