Important note: Data explained in this topic is also relevant to the Java middleware.
Access
The details below are displayed when the selection of data to be transferred concerns the Windows Middleware, in the Data copy tool.
General input parameters
This panel is displayed when data is read from a PC server via the Windows Middleware.
Data entry
Schema
Owner of the tables from which the data is to be exported.
Optional entry.
Filter
Table name display filter.
Default: " * ".
Limit buffer
Optimum size (in Kb) of the generated network buffer.
Check boxes
Allow lowercase/uppercase (in SQL names)
Allows to deactivate the uppercase input control on the schema's name.
It also lets you deactivate the control on destination objects' names.
Object input parameters
This panel is displayed when you select an object if the data source is a PC server.
Data entry
Select clause
WHERE clause in the SQL query that produces the data.
The extract query is constructed as follows: 'select * from <schema>.<table> where <clause>'.
Optional entry.
General output parameters
This panel is displayed when data is inserted into a PC database.
Data entry
Schema
Owner of the tables into which the data is to be imported.
Optional entry.
Limit buffer
Optimum size of the generated network buffer.
Lists
Insertion mode
Data insertion mode.
Possible values:
Insert |
The data is added to the table. |
Replace |
The data replaces those already in the table. |
Update |
The data is updated or added, based on the table's primary key. If the table does not have a key, or if the key contains all the columns, the data is added. |
Check boxes
Allow lowercase/uppercase (in SQL names)
Allows to deactivate the uppercase input control on the schema's name and destination objects' names.
Object output parameters
This panel is displayed when you select an object if the data's destination is a PC database.
Data entry
Delete clause
WHERE clause in an SQL query that deletes data from the destination table.
This clause is taken into consideration if the data insertion mode is set to "REPLACE".
The delete query is then constructed as follows: 'delete from <schema>.<table> where <clause>'.
Optional entry.
Lists
Insertion mode
Data insertion mode.
Possible values:
Default |
Uses the insertion mode specified in the general parameters. |
Insert |
The data is added to the table. |
Replace |
The data replaces those already in the table. |
Update |
The data is updated or added, based on the table's primary key. If the table does not have a key, or if the key contains all the columns, the data is added. |