TRANSFER

Use the TRANSFER command to transfer the contents of one database table to another database table.

Syntax

TRANSFER 'tablename' FROM readername TO writername [ AS 'tableformat' ] 
{ DELETE | DELETE condition | DO NOT DELETE }
[ USE TRANSFER_MAP ] [ USING FILTER filter_clause ];

You can use this command to transfer tables between Sybase, Oracle, Informix®, ODBC, CORBA, and Socket Writer gateways.

The AS tableformat clause specifies the format of the destination table if it is different from the source table format.

The DELETE and DO NOT DELETE clauses define how the destination table is processed. By default, the contents of the destination table are deleted before the contents of the source table are transferred. You can optionally specify a condition that determines whether the deletion occurs. If you specify the DO NOT DELETE clause, the contents of the destination table are not deleted before the contents of the source table are transferred.

Note: The DELETE clause does not function with the Socket Writer Gateway and the CORBA gateways.

The USE TRANSFER_MAP clause instructs the gateway to use the mapping definition that is assigned as the map to the writer used in the TRANSFER command. The USE TRANSFER_MAP clause is only available for use with the Oracle Gateway.

An optional filter clause can be applied by specifying USING FILTER followed by the filter. Enter a valid filter.

Example

TRANSFER 'alerts.conversions' FROM NCO_READER TO SYBASE_WRITER AS
'alerts.conversions' DELETE;
TRANSFER 'alerts.status' FROM NCOMS_READ TO DENCO_WRITE AS 'ncoms.status'
USING FILTER 'ServerName = \'NCOMS\'' DELETE USE TRANSFER_MAP;