×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 02/24/2020
10:15:58 PM:
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.
I believe that using a linked server definition is the easiest
way. The following talks about it -- but not how to create the linked
server definition.
https://stackoverflow.com/questions/18618071/call-db2-stored-procedure-from-sql-server-2008-linked-server/34195157
But perhaps you already know how to do that.
https://www.sqlshack.com/how-to-create-and-configure-a-linked-server-in-sql-server-management-studio/
Sincerely,
Dave Clark
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
