Ideal Requirements for Batch Sequential Processing
search cancel

Ideal Requirements for Batch Sequential Processing

book

Article ID: 56232

calendar_today

Updated On:

Products

Datacom DATACOM - AD Ideal Datacom/AD Datacom/DB Datacom/Server

Issue/Introduction

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.