How to make this script work on Informix

[ecaribe]

We are trying to get this script to work on Informix, but when it gets to(left(@FromDate,2)+'/01/'+right(@FromDate,2))
it comes out with an error -201. This is a SQL statement and want it work on Informix, but I don;t know how to make it work.



SELECT timecard.ttk, matter.mclient, timecard.tmatter,
SUM(timecard.tworkhrs), '*' as EvaluatorID FROM timecard, matter,
timekeep WHERE ttk=tkinit and tmatter= mmatter and (timekeep.tkeflag =
'Y') AND (timekeep.tktmdate IS NULL) AND
(left(@FromDate,2)+'/01/'+right(@FromDate,2)) <=
(left(twoper,2)+'/01/'+right(twoper,2)) AND
(left(twoper,2)+'/01/'+right(twoper,2)) <=
(left(@ToDate,2)+'/01/'+right(@ToDate,2)) AND (matter.mclient
<>'009999') GROUP BY timecard.ttk, timecard.tmatter, matter.mclient
HAVING SUM(timecard.tworkhrs) >= @MinThreshold

 

[vpshriyan]

Hi,

At this point of time there is no function as left() or right() available in informix. As a workaround you may use substr(string,starting_position,number_of_chars) function to emulate those "ora" functions.

Regards,
Shriyan

 

[ecaribe]

thanks for the help.