A message similar to the following might appear when you attempt to run a query on a DBMS table in SAS Enterprise Guide or in another BI Client application:

This problem occurs if a column name in the table contains a space or a special character.

To solve this problem:

1. In SAS^® Management Console, right-click the table and select Properties from the menu that appears.
2. In the Properties dialog box that displays, click the Physical Storage tab. As shown in the following display, select the Enable Case sensitive DBMS object names and the Enable special characters within DBMS object names check boxes:

   

    

   Note: If you select Enable Case sensitive DBMS object names, the Enable special characters within DBMS object names check box remains active, and you can select it. However, if you select the second check box first, the application automatically selects both check boxes for you, and the first check box is no longer selectable.

3. Click OK.
4. In SAS Management Console, right-click the table again and select Update Metadata from the menu. After the table metadata is updated, you should be able to open the table from SAS Enterprise Guide.