Index question

[stevejbr]

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 formatting it wrong or is this just not possible.
Thanks

 

[CODEMONKEYBRET]

I don't think you can do that! I think the only way round this is for you to add a year column to your table and index that (pretty poor really!)