Re: Issue with Created Index Where...

[Charles Wilt <charles.wilt@xxxxxxxxx>]

CREATE INDEX FileL
  ON FileP ( Field1, Field2, Field3 )
  Where AllInOne = '1'
  RCDFMT MyRcdFmt ADD ALL COLUMNS;

HTH,
Charles

On Thu, Feb 23, 2012 at 3:30 PM, Kurt Anderson
<kurt.anderson@xxxxxxxxxxxxxx> wrote:
> For the first time I'm trying to use Where on a Create Index.  It works, except there are two differences that I'm noticing immediately:
>
> 1.  The File only contains the fields in the key list.
>
> 2.  The File's Format name is not the same as the Physical file's format name, but instead is the name of the index file.
>
> Has anyone run into this?
>
> This file has the correct format name and has all of the physical file's fields:
> CREATE INDEX FileL
>   ON FileP ( Field1, Field2, Field3 )
>
> This file has the incorrect format name and has only the key fields in the file:
> CREATE INDEX FileL
>   ON FileP ( Field1, Field2, Field3 )
>   Where AllInOne = '1';
>
> I'm on IBM i 7.1.
>
> Thanks,
> Kurt Anderson
> Sr. Programmer/Analyst
> CustomCall Data Systems
> --
> 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.