• Print |
• E-mail  |
• Bookmark

When using the LIBNAME ACCESS engine, an incorrect WHERE clause is
generated and passed to Teradata when OR conditions are used and the
variable being subsetted on is a DATE variable.  The OR conditions is
switched to an IN operator.  However, in Teradata the IN operator allows
only constants and won't allow multiple formatting parameters.

So a query with the following WHERE:
     where date = '01jan2002'd or date='03dec2001'd

would generate the following:
     WHERE  ( ("DAT_ESTINZIONE" IN  ('01/01/2002' (DATE, FORMAT
               'MM/DD/YYYY'),'12/03/2001' (DATE, FORMAT
               'MM/DD/YYYY')  ) ) )

which would produce an error similiar to the following:
     ERROR: Teradata prepare: Syntax error, expected something like ')'
     between ')' and ','



A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#011822

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at: