Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Results from a select query using DB2 connector

edited Apr 19, 2018 7:00AM in Integration

Summary

Results from a select query using DB2 connector

Content

I am have a connection to a DB2 database using the DB2 adapter.  I have a select query that returns 5 columns.  It validates fine but there is no output data to map.  I essentially am trying to create an orchestration that runs once per night.  The select statement returns 5 columns of customer related data from our ERP, and stores it in a staging table in MySQL to be used in an autocomplete function in a Visual Builder application.  All my other database select's have been via a stored procedure (and return a single value), I'm not sure how

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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