RE: How to execute an IBM I stored procedure from SQL SERVER

How are you planning on calling the sproc from SQL Server ?

Through a .Net application ?

Do you have a linked server set up ?

Tell us more about the environment as there are a handful of potential options.

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
----------------------------------------------------------------------
message: 1
date: Mon, 24 Feb 2020 15:13:34 -0600 (CST)
from: Tim Feldmeier <tim.feldmeier@xxxxxxxxxxx>
subject: How to execute an IBM I stored procedure from SQL SERVER

Hi, I created a stored procedure on the IBM I.

CREATE PROCEDURE XXXX/PROGRAM
LANGUAGE RPGLE
NOT DETERMINISTIC
CONTAINS SQL
EXTERNAL NAME XXXXXX/PROGRAM

Can someone tell how to execute the stored procedure from SQL SERVER.