Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Select statement with DB2 connector doesn't return anything to map — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Select statement with DB2 connector doesn't return anything to map

Accepted answer
edited Jul 3, 2018 3:41PM in Integration 8 comments


Using the DB2 connector to connect to DB2 over port 446, select statement validates and generates and xsd but there is not outbound mapping.


I administer a test and production customer managed OIC environment 18.2.5. We have an on premise connectivity agent that we use for a majority of our integrations. We have an AS400 that uses DB2 as our main ERP. I can connect to it successfully over port 446 (that's the standard port for DB2 on the as400 not 5000, shouldn't matter though). When I created an integration invoking the DB2 adapter using a simple select statement the it validates the query and generates the XSD, but the outbound mapping does not show anything to map to. Has anyone

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!