Re: Issue with Created Index Where...

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