I am trying to bring data from DB2 into Oracle. DB2 is a Zseries DB, Oracle is 11G.
I have brought all the drives into the correct path (version 3.53.95) and I build a new platform according to what I've seen and experienced on the net.
The new platform seems to behave fine (retrieving schema, tables and views list), but when trying to unload data, it gives me an error:
com.ibm.db2.jcc.b.eo: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=GGDWHET;SELECT;DB2OWNER.TPARKAT, DRIVER=3.53.95
This is a very simple 1-1 mapping - I used SQL_TO_ORACLE loading code template from unloading data.