2.4.1.6.4 Options

-t <table name>

Mandatory option.

The name of the database table to be unloaded. When MT_DSNUTILB_LOADUNLOAD is set to "yes", the value for this option can be one of the following two formats: TableName, SchemaName.TableName

When the value doesn't contain schema name, the called COBOL program name is: ${MT_DB_DEFAULT_SCHEMA}-TableName-U

When the value contains schema name, the called COBOL program name is: SchemaName-TableName-U

-o <output flat file>

Mandatory option.

The ddname of the file containing the unloaded data.

-s <DB_SYSTEM>

Specifies the DB SYSTEM. This "DB SYSTEM" value is used to get the "DB connection credential string" from file specified by global variable MT_DB2_SYSTEM_MAPPING. And then apply it to MT_DB_LOGIN. After this API is executed successfully, MT_DB_LOGIN is restored.

-u <utility name>

• When MT_DSNUTILB_LOADUNLOAD is set to yes.

  If this option is set to -u DSNTIAUL, the data file that this utility generates on Batch Runtime has the same format as the data file that utility DSNTIAUL generates on mainframe. If this option is set to other values or if this option is not set, the data file that this utility generates on Batch Runtime has the same format as the data file that utility DSNUTILB generates on mainframe.

• When MT_DSNUTILB_LOADUNLOAD is not set to yes.

  The data file that -u <utility name> generates is simply in text format (rather than binary format).