MBDT - JCL batch utilities tab

Database Selection

HCOSS: For SQL Server databases in which dynamic SQL statements are z/OS DB2 statements. This option is required when you are using HCOSS to migrate the database and your code contains z/OS DB2 SQL statements.
Agnostic: Default. For SQL Server, DB2 for z/OS, Oracle, and PostgreSQL databases in which dynamic SQL statements are specific to the DBMS vendor specifications.

Commit

Single commit...: Default. Perform a single commit after all records have been loaded.
Multiple commits...: Perform a commit each time the Batch Size value has been reached.
Batch Size: When Multiple commits... is selected, the number of rows to process before performing a commit.

Date format

Input Data

ISO	Default. LOAD accepts only Date values in ISO format.
EUR	LOAD accepts Date values in both EUR and ISO formats.
USA	LOAD accepts Date values in both USA and ISO formats.

Output Data

ISO	Default. UNLOAD accepts only Date values in ISO format.
EUR	UNLOAD accepts Date values in both EUR and ISO formats.
USA	UNLOAD accepts Date values in both USA and ISO formats.

Fail if LRECL of SYSREC is greater than row size

Default is unchecked. When checked, the LOAD fails when the LRECL of SYSREC is found to be greater than the row size.