An incorrect WHERE condition might be generated when you use the SQL procedure to query a database table. The problem occurs when both of the following conditions apply:

• You use the META engine.
• The column positions in the metadata table are different from the column positions in the database table.

  Note: Column positions can easily differ between these two tables due to changes such as columns being hidden or being manually moved or deleted.

The problem occurs because the PROC SQL query applies column attributes to a database column based on the column's position in the metadata table. When the attributes do not match, such as when a datetime format is matched with a character data type, an error might also occur.

Note: The error that is returned varies depending on what database you are using.

To circumvent the problem, use the native LIBNAME engine for the database such as ORACLE, TERADATA, GREENPLM, OLEDB, or HADOOP.

If you must use the META engine, you can circumvent the problem by completing the following steps to arrange the columns in the metadata table to match the order of the columns in the database table:

1. Open SAS^® Management Console.
2. Select Environment Management ► Data Library Manager and then click your-library.
3. Right-click the table and click Properties.
4. In the EMP Properties dialog box, click the Columns tab.
5. Drag the columns so that they are in the correct order.
6. When you save the changes, click Yes to save the new order.

Click the Hot Fix tab in this note to access the hot fix for this issue.

The hot fix addresses the problem for Greenplum only.

Refer to the Fixed column of the Operating System and Release Information table below to find the release number in which this problem is addressed for your database.

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to Greenplum 9.4_M2 is available at: