 |
|
| Customizing Your Session and Using Advanced Features |
Handling Embedded Blanks in Column Names
DB2, DB2/2, DB2/6000, ORACLE, and ODBC column names can contain blanks. The SQL Query Window encloses column names in double quotation marks for these access modes to support any blanks within the column name string. Some ODBC drivers might not support double-quoted column names. To avoid conflicts with ODBC drivers, follow these steps:
-
Select Profile
![[arrow]](../../../../common/61991/HTML/default/images/arrow.gif)
Set Preferences. -
In the Preference Settings for Profile window, set Access Mode to ODBC . Enter the data source, user name, and password, and select .
-
In the Preference Settings for ODBC Access Mode window, select Exclude double quote around column names.
|
|
Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.