What are the Ideal requirements for Batch Sequential Processing?
Environment
Release: Ideal for Datacom
Resolution
To improve Ideal batch performance, it is recommended that Datacom/DB sequential processing (GETIT and GSETL commands) be used whenever appropriate.
The following conditions must be met before GETIT and GSETL sequential processing is invoked:
Traversal must be by a key that is no more than 90 bytes in length.
All records in the key range must satisfy the WHERE criteria.
The internal data retrieval order must match the default order, or the order explicitly specified in an ORDERED BY clause. Neither UNIQUE nor DESCENDING may be specified in an ORDERED BY clause.
The record count in a FOR FIRST n statement must be greater than 10.
The WHERE clause must not contain the clauses NOT EQUAL, CONTAINS, or OR.
The active User Requirements Table (URT) specifies a non-zero value for SEQBUFS.