This table shows all
data types and default SAS formats that
SAS/ACCESS Interface to OLE
DB supports. It does not explicitly define the data types as they
exist for each data source. It lists the types that each data source's
data type might map to. For example, an INTEGER data type under DB2
might map to an OLE DB data type of DBTYPE_I4. All data types are
supported.
OLE DB 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DATETIME m.n,
where m depends on precision
and n depends on scale
|
|
|
The following table
shows the default data types that
SAS/ACCESS Interface to OLE DB uses
when creating DBMS tables.
SAS/ACCESS Interface to OLE DB lets you
specify non-default data types by using the
DBTYPE= data set option.
Default OLE DB Output Data Types
|
|
|
DBTYPE_R8 or DBTYPE_NUMERIC
using m.n if the DBMS allows
it
|
|
|
|
|
|
|
|
|