Specify the organization of the table. Values are R, U, S, D, and H. The default is R.
New rows are added to the end of the table if a table has Random organization. When a row is deleted, the last row moves to the vacated position. This organization keeps overall data movement to a minimum. Searching must be done with the Serial method.
The order of the rows is controlled by the user. Searching must be done with the Serial method.
Rows are ordered by key in ascending sequence. Various search techniques can be used. Insertion and deletion tend to be slower than Random and user-ordered organization because rows must be moved to maintain the sequence.
This is the same as Sequential order, except rows are ordered in descending sequence.
Rows are organized by arithmetic operations on the key fields.