Re: Issue with Created Index Where...

["Raul A. Jager W." <raul@xxxxxxxxxx>]

The ability to use "where" in create index is new, when you use it you 
also need to tell it which fields you want to include and the name of 
the format.
After the "where" you should put:  RCDFMT  name, and the columns you 
want in the index (it looks more like a view)  Use:  ADD ALL COLUMNS or 
ADD KEYS ONLY (default) or ADD column name ,...

Kurt Anderson 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
>