Use transfer from when you want to transfer data from a secondary database, either Adaptive Server or another database through another DB2 access service, to the primary database. The primary database, DB2, is the target and is implied in the transfer statement; the secondary and source database is specified in the transfer statement.
The following figure shows the data flow of one of the preceding transfer from examples, which transfers data from sstable3 in Adaptive Server to replace data in the DB2 table named db2table1.
Figure 9-1: DB2 bulk copy “transfer from” statement
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
