Re: sql help

You could simply try the following modification:

WHERE cmtclaim =: claimn and
timestamp(cmtdate,cmttime) <= timestamp(:datein, :timein)

It seems that the statement isn't being parsed correctly--i.e., you have
no parameter markers so EGL/JDBC (or whatever driver you're using) is
parsing the statement incorrectly. Try inserting a space before the
second host variable. Either that or your solution of defining your own
timestamp variable and using it in place of the two host variables.

Just a thought.

egl-i-bounces@xxxxxxxxxxxx wrote on 03/13/2009 01:00:03 PM:

date: Thu, 12 Mar 2009 19:21:12 -0400
from: "tim" <tim2006@xxxxxxxxxxx>
subject: [EGL-i] sql help

Im trying to do the following, but it doesn't seem to like it



get comment with #sql{

select cmtclaim, cmtdate, cmttime, cmtcomm, cmtuser, cmtprior, cmttype

from NTFILES.CLMNOTESL2

WHERE cmtclaim =: claimn and

timestamp(cmtdate,cmttime) <= timestamp(:datein,:timein)

};



Im getting message:



java.rmi.RemoteException: EGL0504E GET: [SQL0418] Use of parameter

marker

not valid.[sqlstate:42610][sqlcode:-418]





any suggestions?