Q:

We can use Excel and ODBC drivers to tap into data in Access, MS-SQL, etc. Is it possible to do the same against mainframe DB2 files? What does it take for nonprogramming Excel users to "connect" to MVS DB2 tables and issue simple query by example?

A:

Clay Rehm’s Answer: I have used Microsoft Access as a query and reporting tool while using DB2 tables located on the mainframe. This requires the specific drivers and communication software to allow this, which has been around for a while (I was doing this in 1994). Once you have linked in the DB2 tables into the Access database, you can view the data directly or run queries using the query by example method. Microsoft Excel can connect to DB2 tables once you have chosen and created your data source. You would create a new database query or can refresh the data in an existing one. However, you do not get the fancy QBE mechanism you get using Access. When creating the new database query, the user would need to select the appropriate data source (the DB2 database) and the tables, columns, filters and sort orders for the query.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access