MFDataTransferCtlr command

Syntax:

{MFDataTransferCtlr16 | MFDataTransferCtlr17 | MFDataTransferCtlr19} 
  DB2=DB2dsn; 
  [U1=DB2userID;] 
  [P1=DB2Password;] 
  SRV=SQLServerDSN; 
  [U2=SQLServerUserID;]
  [P2=SQLServerPassword;] 
  X=["]DataTransferList["];
  [XLocal={TRUE | FALSE};] 
  [TRIG={TRUE | FALSE};] 
  [CONSTR={TRUE | FALSE};] 
  [ErrROW={TRUE | FALSE};] 
  [TYPELOG={CONSOLE | FILE | BOTH};]
  [CQUERY="SELECT projectionList FROM tableName [searchCondition][optionalClauses]";]
  [ADJBUF={TRUE | FALSE};]
  [BUFROWS=n;]
  [CSIZE=n;]

Parameters:

MFDataTransferCtlr16

The name of the command for SQL Server 2016.

MFDataTransferCtlr17

The name of the command for SQL Server 2017.

MFDataTransferCtlr19

The name of the command for SQL Server 2019.

DB2

The name of a cataloged and registered DB2 data source.

U1

The user ID required to access the DB2 data source specified by the DB2 parameter, if applicable.

P1

The password required for the user ID specified by the U1 parameter, if applicable.

SRV

The name of a cataloged and registered SQL Server data source.

U2

The user ID required to access the SQL Server data source specified by the SRV parameter. Not required when using Windows authentication.

P2

The password required for the user ID specified by the U2 parameter, if applicable.

X

The name of a transfer data task file containing a list of tables to be transferred and the queries required to transfer the data. Do not specify a file extension. The file extension for a transfer data task file is .hcodtt. If the transfer data task file name contains spaces, surround it with a set of double quotes ("). You can create a transfer data task file using the UI version of the HCOSS Transfer Data tool, or you can create one manually in a text editor. If you create a transfer data task file using the UI version of the tool, its location is determined by the selection of either the Local or Shared button for the transfer data task. If you create a data transfer task file manually, you must store it in the \DataTasks subdirectory of either the directory specified by the Local HCOSS Directory HCOSS option or the Shared HCOSS Directory HCOSS option.

XLocal

Determines the location of the transfer data task file. Transfer data task files are stored in the \DataTasks subdirectory of either of the following, depending on the value specified:

TRUE	Directory specified by the Local HCOSS Directory HCOSS option. Default.
FALSE	Directory specified by the Shared HCOSS Directory HCOSS option.

TRIG

Specifies whether or not to fire all triggers during the data transfer. Default is FALSE.

CONSTR

Specifies whether or not SQL Server performs all defined checks during the data transfer. Default is FALSE.

ErrROW

Specifies whether or not HCOSS logs errors encountered during the data transfer. Default is FALSE.

TYPELOG

Sets the type of logging to perform. Defaults to the equivalent of the value specified for the Type of logging to do HCOSS option.

CQUERY

Specifies a customized SELECT statement that retrieves data from the source table in which the projection list, optional search condition, and optional clauses can be tailored.

Note: When an expression replaces a column entry in the projection list, the column name has to be maintained by using the same name as the alias. For example, cast(Col1 as binary(8)) as Col1.

ADJBUF

Specifies the AutoAdjustBufferSize property of the DATAFLOW of the SSIS package. Default is FALSE.

BUFROWS

An integer that specifies a value for the DefaultBufferMaxRows property of the DATAFLOW of the SSIS package. Default is 1000.

CSIZE

An integer that specifies a value for the FastLoadMaxInsertCommitSize custom property of the OLE DB Destination of the SSIS package. Default is 1000.

Comments:

Before running this tool, be sure that the appropriate target tables exist in the SQL Server database.

Examples:

MFDataTransferCtlr DB2=MVS91; SRV=HCODemo; X=LocalTransferList

MFDataTransferCtlr DB2=MVS91; SRV=HCODemo; X=SharedTransferList; XLocal=FALSE