Previous Topic Next topic Print topic


MFDataTransferCtlr command

Executes the HCOSS Transfer Data tool from the command line.
Restriction: This topic applies to Windows environments only.

Syntax:

{MFDataTransferCtlr | MFDataTransferCtlr16} 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};]

Parameters:

MFDataTransferCtlr
The name of the command for SQL Server versions earlier than SQL Server 2016.
MFDataTransferCtlr16
The name of the command for SQL Server 2016.
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.

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
Previous Topic Next topic Print topic