DB2 Connect Calling a DB2 Stored Procedure

Diane Koher

DB2 Connect Calling a DB2 Stored Procedure
Hello,

Has anyone been successful at calling a DB2 Stored procedure from SQL
Server?

I've tried using SQL Server DTS to call a DB2 stored procedure using a
query. Its seems to execute the query but has trouble returning the
results.

An example of my statement is
{ CALL SYSPROC.SPNAME('A', 'B', 'C')}

I get a pointer error and some other errors I have seen are:
"Unspecified Error.. Invocation of routine SYSIBM.SQLTABLES Context
GetRowSet to get DBSCHEMA_Tables .. not supported.."

and
"Error calling GetColumnInfo ... You provider does not support all the
interfaces/methods required by DTS"

I'd like to know if it is possible before spending any more time trying
to make it work.

Thank you.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm