Calling DB2 Stored Procedure From SQL Server Store Procedure

I'm a commerical software developer. My company has received a request from
one of our larger clients asking for something which I consider a little
bizarre, but a lot of the requests we get from clients fall into that
category.
Anyway, this client wants to know if we can write an SQL Stored Procedure
for them that will connect to DB2, and once connected, execute a DB2 stored
procedure.
Our database department is primarily tasked with DB installations, but we
asked them anyway. They have no idea, and neither do none of us, but our gut
reaction is No. But, before going back to our client with a "No", I thought
I'd run this by the real experts.
Does anyone know if this can be done, and if so, how?
Also, if it can't be done, why not? (we need to respond to the client on
this request.)
Thanks.I see no one has answered you yet - well - it was worth a shot...
See you on the other side!
"RMGGray" wrote:
> I'm a commerical software developer. My company has received a request from
> one of our larger clients asking for something which I consider a little
> bizarre, but a lot of the requests we get from clients fall into that
> category.
> Anyway, this client wants to know if we can write an SQL Stored Procedure
> for them that will connect to DB2, and once connected, execute a DB2 stored
> procedure.
> Our database department is primarily tasked with DB installations, but we
> asked them anyway. They have no idea, and neither do none of us, but our gut
> reaction is No. But, before going back to our client with a "No", I thought
> I'd run this by the real experts.
> Does anyone know if this can be done, and if so, how?
> Also, if it can't be done, why not? (we need to respond to the client on
> this request.)
> Thanks.