Welcome to ask SQL Server Central

Question

2

Is executing a DB2 COBOL stored procedure via a SQL Server linked server supported? I am trying to execute a parameterized DB2 OS 390 stored procedure via a linked server on SQL server 2008. All attempts have failed. I cannot find explicit information if this function is supported. Any ideas?

edited Oct 13 at 12:04

Kev Riley♦
5,035●3●13

asked Oct 9 at 19:10

Joe Bogdanski
21●1

Joe: did you get a chance to try this? – RBarryYoung Oct 18 at 19:27

RBarryYoung · Answer 1 · 2009-10-09 23:10:01Z UTC

2

Try using this feature:

EXECUTE('db2-proc-command') AT linked-server

answered Oct 9 at 23:10

RBarryYoung
574●8

SQL Server 2008 and DB2 Stored procedures

1 Answer