Use transfer from when you want to transfer data from a secondary database, either ASE or another database through another DB2 access service, to the primary database. The primary database, DB2 UDB, is the target and is implied in the transfer statement; the secondary and source database is specified in the transfer statement.
Figure 9-1 shows the data flow of one of the preceding transfer from examples, which transfers data from “sstable3” in ASE to replace data in the DB2 UDB table named “db2table1.”
Figure 9-1: DB2 UDB bulk copy “transfer from” statement
