Home » Developer & Programmer » Precompilers, OCI & OCCI » DB2 - Oracle Migration
DB2 - Oracle Migration [message #94328] Wed, 04 August 2004 18:26 Go to next message
Leandro Costa
Messages: 2
Registered: August 2004
Junior Member
We're migrating an application running on DB2, to Oracle, and we found some sources that do a previous read of the result set of a cursor, then it reads until it gets a 100 (ORA-1403 iirc), and then it READS again. This source apparently does run on DB2, but here, we get a 1002 because we're trying to fetch a null cursor. How could we workaround this and have this program run without modifying the code (i.e. some precompiler option) (if there's any way to do it)

Thanks a lot!
Re: DB2 - Oracle Migration [message #94478 is a reply to message #94328] Thu, 16 December 2004 00:03 Go to previous messageGo to next message
vamsy
Messages: 3
Registered: December 2004
Junior Member
Hi,

can any one send few imp doc to migrate db2 to oracle urgent
Re: DB2 - Oracle Migration [message #94479 is a reply to message #94478] Thu, 16 December 2004 01:35 Go to previous messageGo to next message
Leandro Costa
Messages: 2
Registered: August 2004
Junior Member
There are some guides out there that outline the main changes, but if have any doubts, ask for a solution in this thread. I've been working some months on a migration like the one you seem to be doing, and maybe i can help you.

Regards,
Leandro Costa
Re: DB2 - Oracle Migration [message #94480 is a reply to message #94479] Thu, 16 December 2004 03:42 Go to previous message
vamsy
Messages: 3
Registered: December 2004
Junior Member
Hi,

i am using db2-oracle conversion kit i collected oracle reserved words which are columns in db2 tables, now can you please tell me how to proceed further.

thanks,
Vamsy
Previous Topic: Very slow insert into ORACLE
Next Topic: db2-oracle migration
Goto Forum:
  


Current Time: Fri Mar 29 04:59:53 CDT 2024