Call DB2 Stored Procedure from MSSQL Stored Procedure

Question

Does anyone know a way to call a DB2 stored procedure from a MSSQL stored procedure?

The DB2 stored procedure does not pass any parameters and is a simple update.

For example, this does not work:

EXECUTE('{CALL DB2SCHEMA.DB2PROC()}') AT DB2;

Thank you

Answer 1

Hi @Michael Henderson ，

Thank you so much for posting here.

I did some searching since I have limited knowledge about DB2.

Please refer below methods and check whether any of them is working to you.

1. To right-click the linked server's "properties" then -> "Server option" The "RPC" and "RPC Out" option in the right pane need to be TRUE.
2. To use the Microsoft OLE DB Provider for ODBC Drivers and create a new linked server with this provider.
3. Try with below code.
   EXEC ('{CALL DB2SCHEMA.DB2PROC()}') AT YourLinkedDB2Server;

Best regards
Melissa

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October--Users always get connection timeout problem when using multi subnet AG via listener. Especially after failover to another subnet

Answer 2

I tried your solution.

I created a link server using the Microsoft driver.
SELECT statements work but not UPDATES.

Name P not allowed. SQLSTATE 42602 SQLCODE -113

Thanks.