You are here: Available Utilities > D > DB2DB > DB2DB Example 2

DB2DB Example 2

How to convert an Access table into a DB2 table:

db2dbw32 /st=coverage /sd=.\deflib\coverage.dfd /sh=CB5 /tt= coverage2 /td= .\deflib\coverage2.dfd /th=db2

These parameters tell the utility to copy the Microsoft Access source table (coverage), which is associated with a DBHandler called ODBC and is mapped using the COVERAGE.DFD file in the .\deflib directory, to the target table (coverage2), which is associated with a DBHandler called DB2 and is mapped using the COVERAGE2.DFD file in the .\deflib directory.

In this example, your FSIUSER.INI file contains entries similar to these. The DB2 table, coverage2, is contained in the DB2 database, CP_Xpress.

< DBHandler:DB2 >

  Database	= CP_Xpress

  BindFile	= c:\dap32103\dll\db2lib.bnd

  Connect	= Yes

  CreateTable	= Yes

  UserID	= db2admin

  Debug		= Yes

  PassWd	= MVF

< DBHandler:ODBC <

  Server	= cpxpress

< DBTable:Coverage <

  DBHandler	= ODBC

< DBTable:Coverage2 <

  DBHandler	= DB2

Here an example of the MS Data Sources (ODBC) setup from a conversion: