True/Pointer Tables

Here you must specify whether the table is to be a T (True) or a P (Pointer) table. The default value for this field is P.

A true table stores and retrieves the actual table rows in the manner specified by the table organization and search method assigned to it. A pointer table stores the actual rows in a randomly ordered table that is accessed indirectly through pointers. Organization and search method actually apply to the index. The appearance of the table to the user is identical whether the table is a true table or a pointer table.

In Release 6, internally, all tables are maintained through indexes (pointer table).

In cases where multiple Indexes are to be created for a Data Table, the table must be defined as a pointer table.

In order to create an Alternate Index, the Data Table must be defined as a pointer table.