Request Records

The request record stores information about the status of a background process. A request record defines the input data that a background process uses to complete a unit of work, and it contains these fields:

Term	Definition
OPRID and RUN_CNTL_ID	Identifies a request set, which can be made up of multiple requests.
REQUEST_NBR or REQUEST_ID	Identifies the individual requests within that request set.
PROCESS_FREQUENCY	Indicates whether to process a request every time the request set is processed or only the next time.
PROCESS_STATUS	Indicates the success or failure of the request once it is processed.
DTTM_STAMP_SEC	Stores the date that the request was last processed.

When a background process starts, it reads the first request record that is flagged for processing. After the record is read, it is immediately updated as In Process and committed by the background process. This prevents other instances of the process from reading and processing the request, and provides information about the current status.

If the PROCESS_FREQUENCY field value is Process Once, the process changes the value to Don't Process when the request is complete. The process updates the PROCESS_STATUS field to reflect the success or failure of the run, and it issues a commit immediately after the update.