database - Informix Error Creating Function : SQL error(-999) Not implemented yet -
i'm getting sql error(-999) not implemented yet in below query inside function:
select res.resourcename, res.resourceloginid, res.extension, asd.eventdatetime, asd.eventtype, rank() on (partition res.resourcename order res.resourcename,asd.eventdatetime) agentstatedetail asd join resource res on asd.agentid=res.resourceid asd.eventdatetime between to_date('18/04/2015 00:00:00', "%d/%m/%y %h:%m:%s") , to_date('18/04/2015 23:59:59', "%d/%m/%y %h:%m:%s") , asd.agentid in(2620,2622) , asd.eventtype in(1, 7);
when replace rank statement interger works properly. when execute query rank function separate query (not inside function), i'm getting desired results. have idea why i'm getting error on having query inside function ? alot... note: i'm using server studio client
transferring comment answer.
which version of informix using?
the olap functionality (such rank) added, in 12.10 , maybe later versions of 11.70. if version older that, won't work , you'll need upgrade.
if version supports it, should contact ibm/informix tech support find out whether it's known problem and/or fixed in more recent fix-pack. and, if isn't known problem, report may them.
you should check ids 12.10 knowledge center too.
and comment bharath confirms 'version old' hypothesis:
the informix version lower 11.70 stated.
Comments
Post a Comment