We're using UDB 7.2. I've tried and failed to build an index on a table that used a function as part of the index. ie CREATE INDEX INSTANCE1.IDX0001 ON INSTANCE1.DETAILTBL (PPLINX ASC, YEAR(DOB) ASC) PCTFREE 10 MINPCTUSED 10
It didn't like the YEAR function on the DOB field. Am I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.