On the surface this seems simple to me.  I need to run a query against a DB2 database from inside a Sesame application.  The purpose would be to get a few elements from a row in a table and put those elements into fields on a sesame screen.  Can I use a JDBC connection in any shape or form to run from SBasic to run the query and get the data back?

Our company has DB2 running on a mainframe.  JDBC is the cleanest way to grab data without installing DB2 Connect so you have the ODBC option.  That being said, would an ODBC option work to run a query, grab some data and bring it back to the data entry screen?

The cleanest option would be for the user to enter, for example, a work order number and press "Search".  The search button they press would fire off the query and parse the results and fill in the fields on the screen.  I would gladly entertain less clean options as well.  Anything that's technically possible.....I have a pretty good imagination for these sorts of things. 

-Robert