CODEWITHSUNDEEP
jdbcoracle11gibm-midrangedata-migration
user125687
user125687

Reputation: 85

transfer data between as400 and Oracle

I need to transfer huge amount of data from AS400 to Oracle db. I think to write a java code but I have not developed java for a long time. I think I need to use AS400 and Oracle jdbc drivers at the same time.

Can I write a statement like this:

INSERT INTO ORACLE_DB.TABLE_TARGET SELECT * FROM AS400.TABLE_SOURCE

Upvotes: 0

Views: 1058

Answers (1)

David G
David G

Reputation: 4014

Both databases need different JDBC drivers ... so I don't think you'll be able to easily to an insert on a select.

You will probably have to write a program to do the data transfer. Check out this post for information on using two jdbc drivers.

Upvotes: 1

Related Questions