DB2 export ,import data

DB2 export ,import data

db2 connect to SCION user bpaas using 12345678
db2 disconnect BPAAS

--- 

export to C:\log\DOC_DETAILS.txt of del modified by nochardel coldel0x09 select * from DOC_DETAILS
export to C:\log\DOC_DETAILS.txt of del  select * from DOC_DETAILS
export to C:\log\AUTHOR_DETAILS.txt of del  select * from AUTHOR_DETAILS

export to C:\Users\mydata.txt of del modified by nochardel coldel0x09 select table1.a,table2.d from table1 table2

----

import from '"C:\BpaasWorkspace\Scion\data\sample\postannotations.txt"' of del commitcount 1000 insert into ANNOTATIONS

 

 

-----------