Batch Processing › Batch Processing Overview

Batch Processing Overview

To submit statements in a batch environment, you enter the statements in an IDMSBCF job stream.

Description of Processing

Unless you specify otherwise in a SET OPTIONS statement, IDMSBCF processes statements one at a time, and a COMMIT WORK RELEASE is issued after the last statement in the input stream.

Note: For more information about the SET OPTIONS statement, see Using SET OPTIONS to Select Options.

IDMSBCF Job Stream

An IDMSBCF session consists of a single job step in a batch job stream. In this job step you include the following:

• A declaration of the program IDMSBCF
• All of the statements you want to execute, including optional SET OPTIONS statements

Batch Output

Output is assigned to the file you specify in the IDMSBCF job stream. Output from the execution of a statement includes the following:

• A redisplay of the statement(s) you executed
• Status messages (error messages, warnings, system messages)

Output from the execution of an SQL SELECT statement might additionally include the following:

• Results of execution
• A message stating how many SQL table rows were processed

Return Codes

The following return codes can be issued by the IDMSBCF command processing program:

• 00 - All commands were processed. No errors or warnings were issued.
• 04 - All commands were processed. One or more commands had warnings issued.
• 08 - All commands were processed. One or more commands had errors and were not completely executed.
• 12 - An internal error has occurred. Other messages should have been issued.