O'Reilly logo

The Programmer’s Guide to iSeries Navigator by Paul Touhy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Indexes

An Index is the equivalent of a keyed logical file with no column or record selection defined.

The easiest way to define a new index is to select New → Index from the context menu of a table. You can also select New → Index from the context menu for Indexes. Figure 4.8 shows the definition window f or a new index.

Figure 4.8. Creating a new index.

You must be even more careful when naming indexes than you were when naming tables and columns. For some strange reason, you do not have the option of defining a short name for an index, so it will be system-generated if the length of the Index name exceeds ten characters. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required