Re: Encoded Vector Index

[Charles Wilt <charles.wilt@xxxxxxxxx>]

SELECT is not part of a CREATE INDEX
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_71/db2/rbafzxcindx.htm

All you need is

CREATE ENCODED VECTOR INDEX MYLIB/CR66272 ON MYLIB/TABLE001
(CORP, TYPE, IDNO, ID#, MAJOR, MINOR) INCLUDE(SUM(AMOUNT))

Charles


On Tue, Jan 26, 2016 at 8:30 PM, Englander, Douglas <
Douglas_Englander@xxxxxxxxxxxxx> wrote:

> Does anyone know if there are any PTFs needed to create an ENCODED VECTOR
> INDEX on V7R1? No matter how I code the syntax, I get SQL0199, SELECT not
> expected. I am using examples from IBM handouts. Here is my example:
>
>
> CREATE ENCODED VECTOR INDEX MYLIB/CR66272 ON MYLIB/TABLE001
> (CORP, TYPE, IDNO, ID#, MAJOR, MINOR) INCLUDE(SUM(AMOUNT))
>
> SELECT
> CORP, TYPE, IDNO, ID#, MAJOR, MINOR, SUM(AMOUNT) FROM
> MYLIB/TABLE001 WHERE
> CORP = 100 AND
> ID# <> 0
>
> GROUP BY
>    CORP, TYPE, IDNO, ID#, MAJOR, MINOR
> ORDER BY
>    CORP, TYPE, IDNO, ID#, MAJOR, MINOR;
>
> Thank you,
>
> Doug
>
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.