Errors occur if you use certain operators in a WHERE statement when connecting to a Vertica database with SAS/ACCESS® Interface to ODBC


When you are using SAS/ACCESS Interface to ODBC to connect to a Vertica database, an error is generated if you use a WHERE statement with a "greater than or equal to" operator and a "less than or equal to" operator or the BETWEEN operator.

WHERE SHIP_DATE >= '01JAN2009'd AND SHIP_DATE <='31DEC2009'd

Or:

WHERE SHIP_DATE BETWEEN '31DEC2008'd AND '01JAN2010'd

Using either of the above statements sends a BETWEEN operator to Vertica, and Vertica issues an error similar to this:

ERROR: CLI prepare error: ERROR 4856: Syntax error at or near "'2008-12-31'" at character 1028 SQL statement

To work around this issue, use values greater than or less than and use only the greater than or less than operators without the equal to operator. Here is an example:

WHERE '31DEC2008'd < SHIP_DATE <'01JAN2010'd