Utilities › RMOGRW - General Report Writer › Sequence in Which Database Records Are Accessed

Sequence in Which Database Records Are Accessed

The RMOGRW utility program accesses database records based on the database fields that are referenced. The following guidelines determine the sequence in which database records are accessed:

• If database fields from the job descriptor record are referenced, database records are retrieved in job name (JOB) sequence.
• If database fields from the report descriptor record are referenced other than report identifier (RID), database records are retrieved in report identifier (RID) sequence.
• If database fields from the bundle descriptor record or bundle active status record are referenced without referencing database fields from the job descriptor record, report descriptor record, or report active status record other than report identifier (RID), database records are retrieved in bundle identifier (BID) sequence.
• If database fields are referenced from the distribution data record only, database records are retrieved in distribution identifier (DID) sequence.

Because the database fields that are referenced do not necessarily imply the true intent of your request, the sequence in which database records are accessed can be overridden by the CONTROL control statement.