If you are working in a complex environment in which you need to move data between a host database system and a workstation, you can use DB2 Connect™, the gateway for data transfer between the host and the workstation.
The DB2® database export and import utilities allow you to move data from an IBM mainframe server database to a file on the DB2 Connect workstation, and the reverse. You can then use the data with any other application or relational database management system that supports this export or import format. For example, you can export data from an IBM mainframe server database into a PC/IXF file, and then import it into a DB2 for Linux, UNIX, and Windows database.
With DB2 Connect, export and import operations must meet the following conditions:
The following example illustrates how to move data from a workstation to a host or System i server database.
Export the data into an external IXF format by issuing the following command:
db2 export to staff.ixf of ixf select * from userid.staff
Issue the following command to establish a DRDA® connection to the target DB2 database:
db2 connect to cbc664 user admin using xxx
If it doesn't already exit, create the target table on the target DB2 database instance:
CREATE TABLE mydb.staff (ID SMALLINT NOT NULL, NAME VARCHAR(9),
DEPT SMALLINT, JOB CHAR(5), YEARS SMALLINT, SALARY DECIMAL(7,2),
COMM DECIMAL(7,2))
To import the data issue the following command:
db2 import from staff.ixf of ixf insert into mydb.staff
Each row of data will be read from the file in IXF format, and an SQL INSERT statement will be issued to insert the row into table mydb.staff. Single rows will continue to be inserted until all of the data has been moved to the target table.
Detailed information is available in "Moving Data Across the DB2 Family," an IBM Redbooks® publication. This Redbooks publication can be found at the following website: www.redbooks.ibm.com/redbooks/SG246905.