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:
  1. Select Profilethen selectSet Preferences.
  2. In the Preference Settings for Profile window, set Access Mode to ODBC. Enter the data source, user name, and password, and select OK.
  3. In the Preference Settings for ODBC Access Mode window, select Exclude double quote around column names.
Copyright © SAS Institute Inc. All rights reserved.