question

Joe Bogdanski avatar image
Joe Bogdanski asked

SQL Server 2008 and DB2 Stored procedures

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?

stored-proceduresdb2supported
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RBarryYoung avatar image RBarryYoung commented ·
Joe: did you get a chance to try this?
0 Likes 0 ·

1 Answer

·
RBarryYoung avatar image
RBarryYoung answered

Try using this feature:

EXECUTE('db2-proc-command') AT linked-server
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.