Forum Discussion
Help on using IBM DB2 Z/OS Mainframe stored procedure result set (data) in PowerBI report
Hi All, I am trying to create a report by executing a DB2 stored procedure on the mainframe (Z/OS). The stored procedure returns a single result set. Stored procedure works fine when tested but w...
OleDb.DataSource("provider=IBMDADB2.DB2COPY1; data source=DB2EMPA", [Query="CALL EMPLOYEE.SUMMARY1('MATHS', '5');"])
Resolved. Using OLEDB instead of ODBC helped to get the returned result set from SP.
Note: IBMDADB2.DB2COPY1 is the installation default IBM DB2 OLE DB provider.
ODBC provides access only to relational databases
OLE DB provides the following features
Access to data regardless of its format or location
Full access to ODBC data sources and ODBC drivers