DBTYPE=

DBTYPE=

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

Default value: VARCHAR(size) is the default for SAS character variables where size is derived from the length of the SAS variable. DATE is the default for SAS date variables, TIME is the default for SAS time variables, TIMESTAMP is the default for SAS datetime variables, and DOUBLE is the default for all other SAS numeric variables.

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