Load multiple tables from Oracle to DB2

ITDW · Post by **ITDW** » Mon Jul 25, 2011 6:38 am

Hi , I am new to data stage , I want to load the 360 tables from oracle to db2 tables in one or 2 jobs .please help me to design the Job .

Moderator: split from this post so you can have your own post / discussion / solution.

Karthik.M · Post by **Karthik.M** » Mon Jun 18, 2012 3:55 am

Create individual jobs for each table with Oracle Connector stage as source and DB2 Connector as target with valid configuration details for both Database stages.
Also a valid DSN or ODBC connection must be established by Datastage with both databases.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 18, 2012 5:18 am

If there are no large objects (BLOB or CLOB), and provided that you are using DB2 Timestamp data type where Oracle has TIME, you will be able to do this with one or two jobs quite easily using Runtime Column Propagation.

Even if there are large objects it can be achieved with few jobs, but you have to generate SQL (in a sequence, probably) to convert the binary data into hex encoded when selecting and back again when inserting.

I have done this, except that the target was MySQL.

vamsi.4a6 · Post by **vamsi.4a6** » Mon Jun 18, 2012 6:22 am

I think the following link will help you

http://isecor.com/drupal6/node/163

Replace target by DB2 Stage

chulett · Post by **chulett** » Mon Jun 18, 2012 6:31 am

I imagine they've solved this problem by now.