Running DB2 Stored Procedures from Microsoft SQL Server 2000

[Westwood]

I have looked the newsgroups up and down and can't seem to find any
information on this topic so I'm hoping this group can help me.

We are a DB2 and SQL Server shop. Most of the time we are using
ADO.NET to access DB2 stored procedures in the PC side, but we need to
be able to run a DB2 stored procedure within SQL Server. More
specifically we need to run them from within a DTS package and within a
SQL Server stored procedure. I have found how I can run SQL Server
stored procedures from within these things, but nothing on DB2 yet.

If anyone out there can help me with this I would be very grateful and
if you could be as detailed as possible I would really appreciate it.

Thanks,
Westwood

[Serge Rielau]

Westwood wrote:

I have looked the newsgroups up and down and can't seem to find any
information on this topic so I'm hoping this group can help me.

We are a DB2 and SQL Server shop. Most of the time we are using
ADO.NET to access DB2 stored procedures in the PC side, but we need to
be able to run a DB2 stored procedure within SQL Server. More
specifically we need to run them from within a DTS package and within a
SQL Server stored procedure. I have found how I can run SQL Server
stored procedures from within these things, but nothing on DB2 yet.

If anyone out there can help me with this I would be very grateful and
if you could be as detailed as possible I would really appreciate it.

Thanks,
Westwood

Hmm, as long as you don't do COMMIT within the procs here is a rather
mean idea.
Prereq DB2 V8.2
CREATE FUNCTION wrapProc(in INT)
RETURNS TABLE(out INT)
MODIFIES SQL DATA
BEGIN ATOMIC
DECLARE out INT;
CALL Proc(in, out);
RETURN VALUES(out);
END

Now you can execute the proc via regular SQL presuming you have some
form of query connectivity from SQL Server to DB2.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab