RE: V6R1 CREATE INDEX

Create your index over the physical file referenced by the view. Query
engine should pick up the index when you query the view based on your
order by and select by clauses in the query.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, September 09, 2008 9:24 AM
To: midrange-l@xxxxxxxxxxxx
Subject: V6R1 CREATE INDEX

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.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.