Re: sql help

[Jason Abreu <abreuj@xxxxxxxxxxxxxxxxx>]

EGL SQL does not support everything that SQL can do.
For instance, it doesn't support the WITH clause
(WITH table1 as ..., table2 as ..., etc).
So the #sql in EGL may not support the timestamp function.

I believe the best solution would be to use a prepared statement.
That's all I use any more because of the control I have over the SQL 
statement.

If you have any questions, feel free to email me directly.

Try this:

prepare myStmt from
"select cmtclaim, cmtdate, cmttime, cmtcomm, cmtuser, cmtprior, " +
"cmttype from NTFILES.CLMNOTESL2 where cmtclaim = ? and " +
"timestamp(cmtdate, cmttime) <= timestamp(?, ?) ";

try
  get comment with myStmt using claimn, datein, timein;
onException (exc AnyException)
  //process exception
end

--Jason

tim wrote:
> 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?