I can't seem to get the V6R1 index enhancements to support either CASE or UDFs. Is that a limitation or am I mucking it up?
create index rob/jeff10l1 on rob/jeff10 (mykey) RCDFMT JEFF10L1R ADD mykey, pordcode, pord, cost, Myudf(cost, pordcode, pord) as price
Token ( was not valid.
create index rob/jeff10l1 on rob/jeff10 (mykey) RCDFMT JEFF10L1R ADD mykey, pordcode, pord, cost, case when pordcode='P' then cast(cost*pord as dec(15,5)) else cast(cost+pord as dec(15,5)) end as price Keyword WHEN not expected.