Summary of DB2 Import and export methods

1. Exporting a DEL text file

 to  of  Select* from

2. Export the ixf text file. ixf file contains table structure and DB2 database information

Export to D:\T_TESTTABLE20121220.IXF of IXF select * from [email protected]

3. Inserting data into the data

 from  of  Insert into

 from  of  Insert into

4. Data substitution for imported data

 from  of  replace into from the replace into 

5. Import data to create table structure and import data

 from  of  Create into

6. Import Data Load Import table data

LOAD  from  of   insert intoLOADfrom of insert   into [email protected]

7. The import data contains a table with ID generated always generated by the system

LOAD  from  of  byINSERT into

8. Import data del file to solve the Chinese garbled

LOAD  from  of   by codepage=1386INSERT into

If there is a Chinese garbled and identity, codepage write the front
9. When importing the load table of the data, the table locks dead

LOAD  from  of   into

Summary of DB2 Import and export methods