This table shows all data
types and default SAS formats that
SAS/ACCESS Interface to ODBC supports.
It does not explicitly define the data types as they exist for each
DBMS. It lists the SQL types that each DBMS data type would map to.
For example, a CHAR data type under DB2 would map to an ODBC data
type of SQL_CHAR. All data types are supported.
ODBC Data Types and Default SAS Formats
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
m or m.n or
none if m and n are
not specified
|
|
m or m.n or
none if m and n are
not specified
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ODBC cannot support
fractions of seconds for time values
|
|
DATETIME m.n where m and n depend
on precision
|
1Because the ODBC driver
does the conversion, this field is displayed as if the $HEXn.
format were applied.
|
The following table
shows the default data types that
SAS/ACCESS Interface to ODBC uses
when creating tables.
SAS/ACCESS Interface to ODBC lets you specify
non-default data types by using the
DBTYPE= data set option.
Default ODBC Output Data Types
|
|
|
SQL_DOUBLE or SQL_NUMERIC
using m.n if the DBMS allows
it
|
|
|
|
|
|
|
|
|