Use this utility to copy data from one database table to another database table. The database tables can be from a different DBMS, such as one from ODBC and the other from a native DB2 database.
DB2DBW32 /ST /SD /SD /TT /TD /TH
Parameter |
Description |
ST |
Enter the name of the source table. |
SD |
Enter the name of the DFD file for the source table. |
SH |
Enter the type of handler for the source table. |
TT |
Enter the name of the target table. |
TD |
Enter the name of the DFD file for the target table. |
TH |
Enter the type of handler for the target table. |
The source and the target table names must be different. You can rename target table after the conversion to a new database. For example:
db2dbw32 /st=xdb ……. /tt= xdb … (incorrect)
db2dbw32 /st=xdb ……. /tt= xdb2 … (correct)
See the following examples:
© Copyright 2012, Oracle and/or its affiliates. All rights reserved. Legal notices.