3.4.1 Index Name

Mandatory.

Specify the name that is to be assigned to the Index.

Rules

• Must be a valid LANSA Object Names.
• Index names must be unique.

Platform Considerations

• IBM i: If using native RPG programming language, a maximum of 8 character names should be used.
• IBM i: No other physical or index can exist in the same library with the same name.
• IBM i: No library name is required. LANSA will always create the index into the same library as the associated physical table. This is the library that was specified when the table definition was first created.

Tips & Techniques

• Many IT departments adopt a naming standard that requires that index table names contain or relate to the associated physical table name. This is to prevent confusion amongst users when they are accessing the physical or indexes.

• For instance, the physical table (and LANSA table definition) of a customer master table might be named CUSMST. The associated indexes might be called:

  CUSMSTV1	Customers ordered by customer name.
  CUSMSTV2	Customers ordered by postcode.
  CUSMSTV3	Customers ordered by state.