DBTYPE=

DBTYPE=

Specifies data type(s) to override the default ORACLE data type(s) when SAS outputs data to ORACLE.

Default value: VARCHAR2(size) for characters, where size is derived from the SAS variable length; NUMBER(p, s) for numbers, where p and s are derived from the SAS variable format; and NUMBER for numbers where p and s cannot be derived.

Syntax
Details

Syntax

DBTYPE=(<column-name-1=<'>DBMS-type<'>> <...<column-name-n=<'>DBMS-type<'>>>)

Details

For a full description of this option, refer to DBTYPE=.

Chapter Contents
Previous
Next
Top of Page