Chapter Contents

Previous

Next
DBTYPE=

DBTYPE=



Specifies whether or not to override the default DB2 data type(s) when SAS creates a table and outputs data to DB2 tables.

Default value: None


Syntax
Details

Syntax

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


Details

By default, SAS numeric variables are assigned to FLOAT column types and character variables are assigned to VARCHAR column types. Use the DBTYPE= option to override these data type defaults. For a full description of this option, refer to DBTYPE=


Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.