Answered! Hello I have one question that pertains to IBM i. Thank you, and have a great day….

These will act as you expect for an index.

The software that we use does not have any keyed physical files.

They are all logical files.

In a major conversion we can delete all logical files, perform the conversion and recreate logical files much more quickly.

We do not run into the problem of not being able to change a key field since there are truly no keys.

DDS described keyed logical files must be updated in the same way as SQL indexes, i.e. are as expensive as SQL indexes.

But contrary to SQL Indexes , DDS described keyed logical files can share access path with either SQL Indexes or other DDS described logical files, if those objects have the same or less key fields in the same sequence and either the same or a larger page size.

When we specify K in position 17, the name specified in positions 19 through 28 is a key field name.

It must be one of the field names within the physical file record format.

The contents of this field are used to sequence the records for retrieval from the database.

Specifying a key is optional.

If no key field is specified, the default sequence is arrival sequence.

Use key fields to define a keyed sequence access path for record formats in the logical file member.