TRANSFER command

The TRANSFER command transfers data from an ObjectServer table to a target table using a transfer map. The data can also be filtered. This command is most useful is cases where once populated, the target table contents are unlikely to change.

The TRANSFER command takes the following syntax:

TRANSFER FROM 'source' [ TO 'target' ]

The TRANSFER command is usually specified in the startup command file. To run the TRANSFER command from the startup command file use the following example:

TRANSFER FROM 'source_table' TO 'target_table'
			VIA FILTER 'Colname != \'Severity\''
			WITH DELETE VIA 'Column_Name <> \'Severity\''
			USING TRANSFER_MAP GatewayTablesMap;

Note: To replicate data from dynamic secondary tables you must use the Gate.ResyncTables property in the table replication definition file.

This command can also be entered using the SQL interactive interface (nco_sql). For more information about using the SQL interactive interface, see the IBM Tivoli Netcool/OMNIbus Administration Guide.

For more information about the startup command file and the TRANSFER command, see the IBM Tivoli Netcool/OMNIbus Probe and Gateway Guide.