TRANSFER

Initiates a data transfer operation from the specified table in the ObjectServer to the specified table in the Oracle database.

You can transfer a partial data set using a filter condition. If the target table in the Oracle database does not match the source table, a map can be specified as part of the transfer operation. This map must be defined within the gateway's map definition file. For details about the map definition file, see Map definition file.

Note: The TRANSFER command is designed to be used with simple mappings that reference only ObjectServer fields, such as @Identifier. It will not handle gateway cache entries, such as SERVER_NAME.

Syntax

TRANSFER FROM sourcetable TO targettable
[VIA FILTER filtertext] [WITH DELETE VIA delfiltertext]
[USING TRANSFER_MAP mapname] ;

Example

The following examples shows different options for using the TRANSFER command.
# 1)	Transfer the table from table master.names to the Oracle table 
#	reporter_users using the filter condition 'Name != 'nobody' and the map
#	OracleUsersMap.
TRANSFER FROM 'master.names' TO 'reporter_users'
                        VIA FILTER 'Name != \'nobody\''
                        USING TRANSFER_MAP OracleUsersMap;
			                        go
# 2)	This is the same as example 1, but forces a deletion of any existing
#	data in the target table reporter_users that matches the source filter.
#	The delete operation is performed with the  same filter condition used
#	to fetch the source data with. This means that all columns within the
#	source exist in the target with the same name.
TRANSFER FROM 'master.names' TO 'reporter_users'
                        VIA FILTER 'Name != \'nobody\'' DELETE
                        USING TRANSFER_MAP OracleUsersMap;
			                        go
# 3)	Transfer the data from the source table alerts.conversions to the
#	target table reporter_conversions. Delete all data in the target
#	table before the transfer.
TRANSFER FROM 'alerts.conversions' TO 'reporter_conversions' DELETE
USING TRANSFER_MAP OracleUsersMap;
			                        go
4)	Transfer the data from the source table alerts.conversions to the
#	target table audit_conversions. Use the filter condition
#	"Colname != 'Severity'" to select the required data. Delete the data
#	in the target table via the filter "Column_Name <> \'Severity'".
#	This capability overcomes the need for the source and target tables
#	to have columns with the same name.
TRANSFER FROM 'alerts.conversions' TO 'audit_conversions'
			VIA FILTER 'Colname != \'Severity\''
			WITH DELETE VIA 'Column_Name <> \'Severity\''
			USING TRANSFER_MAP OracleAuditConvMap;
			                        go