mbdtconfig command

Syntax

mbdtconfig -t {H[COSS] | A[gnostic]} [-s size={0 | n}] [–c {Y[es] | 
   N[o]}] [–f {I[SO] | E[UR] | U[SA]}] [–m {I[SO] | E[UR] | U[SA]]
   [-r {Y[es] | N[o]}] 

Parameters

-t

Sets the database type.

H[COSS]

Indicates a SQL Server database in which SQL statements are z/OS DB2 statements.

A[gnostic]

Indicates a SQL Server, DB2 for z/OS, Oracle, or PostgreSQL database in which SQL statements are specific to the DBMS vendor specifications. This option does not support mainframe DB2 DDL. Default.

-s

Sets the commit behavior.

size=0

Default. Perform a single commit after all records have been loaded.

size=n

Enables multiple commits. Provide a number to indicate the number of rows to process before issuing each commit.

–c

Sets the LOAD behavior when the LRECL of SYSREC is found to be greater than the row size.

Y[es]

The LOAD fails when the LRECL of SYSREC is greater than the row size.

N[o]

Default. The LOAD continues regardless of the LRECL of SYSREC size as compared to the row size.

-f

Sets the format of DATE values for the input dataset.

I[SO]

Default. The LOAD only acceptS the ISO format (yyyy-mm-dd) for DATE (external) values.

E[UR]

The LOAD accepts the EUR format (dd.mm.yyyy) and ISO format for DATE (external) values.

U[SA]

The LOAD accepts the USA format (mm/dd/yyyy) and the ISO format for DATE (external) values.

-m

Sets the format of DATE values for the output dataset.

I[SO]

Default. The UNLOAD only acceptS the ISO format (yyyy-mm-dd) for DATE (external) values.

E[UR]

The UNLOAD accepts the EUR format (dd.mm.yyyy) and ISO format for DATE (external) values.

U[SA]

The UNLOAD accepts the USA format (mm/dd/yyyy) and the ISO format for DATE (external) values.

-r[3]

Sets the return code of SQLTUL for non-SELECT * statements.

Y[es]

Match the return code of mainframe DSNTIAUL, RC=04.

N[o]

Default. Do not match the return code, instead returning mainframe DSNTIAUL RC=0.