From the HCOSS Transfer Data tool, either create a new transfer data task or open an available transfer data task.
Click the
Customize Transfer Data tab.
Do one or more of the following to customize the task. All are optional:
Edit the
Seq,
Schema name,
Name, or
Buffer rows column for any entry on the
Tables grid.
Note:
Be careful that any new values you enter into column fields are valid within the context of the transfer task. Invalid values can cause Build Query failures.
Edits made directly to the
Query column are not saved.
Change or set the controls in the
Transfer Task Options group to affect all schemas and tables.
Build a WHERE or an ORDER BY into a SELECT statement:
On the
Tables grid, double-click the first column on the left-hand side of the grid for the object you want to customize.
Use the fields and controls in the
WHERE/ORDER BY in SELECT group to construct the clause.
Click
Update to add the WHERE or ORDER BY to the query statement.
Select a method for handling source row data from the
Source Row Data Count group.
Note:
The default setting for
Source Row Data Count when you have not specified a WHERE clause is
Estimate using schema statistics. If you have specified a WHERE clause, the default is
Acutal using COUNT_BIG(*).
You can override the default by specifically selecting an option from the group with one exception. If the default setting is
Acutal using COUNT_BIG(*), you cannot override it by setting it to
Estimate using schema statistics.
Click
Save All to save all customizations.
Optionally, click
Transfer to immediately transfer the data.
Note: You can also transfer the data from the
Transfer Data Tasks tab.
