SAS SQL Query Window User's Guide

Embedded Blanks in Column Names

DB2, DB2/2, DB2/6000, ORACLE, and ODBC column names can contain blanks. The Query Window encloses column names in double-quotes for these access modes to support any blanks within the column name string. Some ODBC drivers may not support double-quoted column names. To avoid conflicts with ODBC drivers:

Select Set Preferences... from the Profile pmenu.
In the Preference Settings for Profile window, set Access Mode to ODBC.
In the Preference Settings for ODBC Access Mode window, select Exclude double quote around column names.

Chapter Contents
Previous
Next
Top of Page