RaptorOfWest
Member
Hi
Needed some help on how to use AIX to connect DB2..We currently are using AIX platform to host our JDE 9.10, which is based on Oracle 11g database. The logic, web and db al reside on the AIX machines. Now we have a conversion requirement where we need to access a foreign table from AS400/DB2 world soft system.
This is a JDE UBE which connects and fetch data from world tables and inserts into JDE with some logic. Now we can work it through Windows(easier) also we can connect similarly to SQL database but couldnt work out how to connect AS400/DB2
Can anyone who may have any insight share their thoughts if this is possible and what can be the options...much appreciated
Error - no driver found, unable to init connect
Steps done - created an environment, datasource with AS400 server and owner(Business Data - As400), added OCM for UBE to process in E910)
Env- AIX 7.1 with JDE 9.1 on Oracle 11g, Foreign - V6r1 AS400/db2 on world soft.
(the steps above works for MSSQL from AIX)
Needed some help on how to use AIX to connect DB2..We currently are using AIX platform to host our JDE 9.10, which is based on Oracle 11g database. The logic, web and db al reside on the AIX machines. Now we have a conversion requirement where we need to access a foreign table from AS400/DB2 world soft system.
This is a JDE UBE which connects and fetch data from world tables and inserts into JDE with some logic. Now we can work it through Windows(easier) also we can connect similarly to SQL database but couldnt work out how to connect AS400/DB2
Can anyone who may have any insight share their thoughts if this is possible and what can be the options...much appreciated
Error - no driver found, unable to init connect
Steps done - created an environment, datasource with AS400 server and owner(Business Data - As400), added OCM for UBE to process in E910)
Env- AIX 7.1 with JDE 9.1 on Oracle 11g, Foreign - V6r1 AS400/db2 on world soft.
(the steps above works for MSSQL from AIX)