Restriction: This topic applies to Windows environments only.
Tables grid
- Seq
- The sequence in which each object is transferred from the DB2 database to the SQL Server database.
- Schema
- The names of schemas containing data to be transferred.
- Name
- The names of tables containing data to be transferred.
- Buffer rows
- The maximum number of rows that can be held in an individual buffer during the transfer.
- Query
- Perform the transfer by running a query against the SQL Server via the SSIS engine.
Transfer Task Options group
- DB2 Isolation Level
- Enables you to customize the DB2 isolation level. The options are:
- CS
- Cursor Stability (default)
- UR
- Uncommitted Read
- RS
- Read Stability
- RR
- Repeatable Read
- Fail on Error
- The data transfer fails when it encounters an error.
- Log Error Rows
- The Transfer Data tool logs an error for each row or series of rows containing an error, based on the number specified in
the
Commit Size field.
- Commit Size
- When
Log Error Rows is selected, this editable field shows the number of error rows to identify before committing to the log file. Default is
10.
- Ignore Error
- The Transfer Data Tool ignores all errors and continues transferring data.
- Fire Triggers
- When checked, HCOSS fires all defined triggers during the data transfer. Default is unchecked.
- Check Constraints
- When checked, SQL Server performs all defined checks during the data transfer. Default is unchecked.
WHERE/ORDER BY in SELECT group
- Build WHERE
- Use the other controls in this group to build an WHERE clause for the query that corresponds to the tables selected on the
grid.
- Build ORDER BY
- Use the other controls in this group to build an ORDER BY clause for the query that corresponds to the tables selected on
the grid.
- Column
- Lists the columns available for the tables selected on the grid.
- Conditional Operator
- Lists valid conditional operators you can use for this clause.
- AND
- Inserts an AND into the clause.
- OR
- Inserts an OR into the clause.
- Value
- A literal value to insert into the clause.
- >
- Move completed clauses to the
Predicate or Sort Order box.
- <
- Remove the clause from the
Predicate or Sort Order box.
- Predicate or Sort Order
- Shows the code for a completed clause.
Transfer List Actions group
- Update
- Updates the selected query with the WHERE or ORDER BY clause in the
Predicate or Sort Order box.
- Save All
- Saves all changes made to all table queries on the
Objects list. Once saved, you cannot revert your changes.
- Revert
- Removes all changes made to the table queries selected on the
Objects list, setting them back to their last saved state. Once saved, you cannot revert your changes.
- Revert All
- Removes all changes made to all table queries on the
Objects list, setting them back to their last saved state. Once saved, you cannot revert your changes.
Source Table Row Count group
- Estimate using schema statistics
- Estimate the row count by querying CARDF in SYSIBM.SYSTABLES. Use this option for optimal performance if your schema statistics
have been recently updated. This is the default setting when you have not specified a WHERE clause.
- Acutal using COUNT_BIG(*)
- Directly query the row count by executing SELECT COUNT_BIG(*) FROM
targetTable. This option provides an accurate count of the rows to be transferred. This is the default setting when you specify a WHERE
clause. Large tables can degrade performance.
Data Transfer Actions group
- Clear
- Clear the data tables in the destination SQL Server database.
- Transfer
- Transfer the data.