Date:         Fri, 15 Aug 2008 05:40:54 -0700
Reply-To:     irinfigvam@yahoo.com
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Irin later <irinfigvam@YAHOO.COM>
Subject:      Re: The syntax of the string representation of a datetime value is
Comments: To: Patrick <patrick.matter@GMX.CH>
In-Reply-To:  <e5386448-fd4a-4795-bef2-3310c0579ea1@k37g2000hsf.googlegroups.com>
Content-Type: text/plain; charset=iso-8859-1

Patrick,
 
Now it generates :
 
ERROR: CLI execute error: [IBM][CLI Driver][DB2/AIX64] SQL0401N The data types of the operands for the operation ">=" are not
compatible. SQLSTATE=42818
 
 
However when I am trying to change operators to GE (LE) it mentions unexpected tokens 
 
Irin 
 


--- On Fri, 8/15/08, Patrick <patrick.matter@GMX.CH> wrote:

From: Patrick <patrick.matter@GMX.CH>
Subject: Re: The syntax of the string representation of a datetime value is
To: SAS-L@LISTSERV.UGA.EDU
Date: Friday, August 15, 2008, 8:16 AM

Hi Irin
The error log mentions a datetime value.
I assume therefore that you have to pass your date values to DB2 as a
datetime value.

If you look at the link I've sent you this would be:
where mc.START_DT >= TIMESTAMP ('2005-01-01 00:00:00')
      and mc.END_DT <= TIMESTAMP ('2007-12-31 24:00:00')

HTH
Patrick