Re: Encoded Vector Index

[Raul A Jager W <raul@xxxxxxxxxx>]

Are you typing all in an interactive session?
You need to "enter" before typing the SELECT

On 01/27/2016 02:03 PM, Jim Oberholtzer wrote:
> While there are PTFs associated with EVI's along the way there are no
> specific ones needed for create.  That was added to the OS awhile back. You
> don't indicate what PTF/TR level your V7R1 system is at.
>
> I think what you're trying to do is create a hybrid EVI and View with a
> group by at the same time.  My guess is that is not supported.  First
> create the EVI then create your view.  The view would utilize the EVI if
> the optimizer thinks it will help.
>
> Is this an index you're trying to create proactively or is it one the
> adviser is calling out?
>
> ---
> Jim Oberholtzer.
>
> On Tue, Jan 26, 2016 at 7: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.


-- Este e-mail fue enviado desde el Mail Server del diario ABC Color -- 
            -- Verificado por Anti-Virus Corporativo Symantec --