I need to load data from Oracle tables into DB2 tables.
What are the procedures? Thanks in advance!

Take a look at the IMPORT/LOAD command, and try to export it into one of the formats listed.

I don't think Oracle supports IXF so one of the ascii formats should do it.

you can load data from Oracle to DB2 ,

get data in dec file by using SQL statement, if table has date , put date in Db2 format , to_char( date,'YYYY:MMD') function





example Otacle table is emp

that has following structure


id number
name varchar2(30)
sal number(7,2)

data is like
1 elr 1000
2 msr 2000
3 est 3000



spool emp.dat
select to_char(id)||chr(36)||chr(39)||name||chr(39)||to_c har(sal)
from emp
spool off

emp.dat , will look like below
1,"elr",1000
2,"msr",2000
3,"est",3000


use emp.dat , load into db2 by using column delimeter,char delimeter

load from emp.dat of del MODIFIED BY CHARDEL" COLDEL, replace into db2.emp


not sure ascci value of " , number

Let me know , if any questions


Thank You


Lekharaju Ennam