luzaolai

 Profile Answers by luzaolai 

• Apr 26th, 2009

 

In db2 three different format (ixf,del,asc) to export data:
Export to tablename.ixf of ixf select * from tablename.
When do import we can define if the original data should be kept or cleaned. Insert will keep the data, replace will clean the original data.
Import from tablename.ixf of ixf insert into tablename

Shaik Kareem

 Profile Answers by Shaik Kareem 

• Jun 6th, 2011

 

exp file=fullprd.dmp logfile=fullprd.log full=y