×
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.
<Dave Clark>
We have a free middleware tool (an *ARDPGM that works with
WRKRDBDIRE) to allow us to use embed SQL in our RPG programs to open
cursors in a cross-platform situation with MS SQL Server, but I am having
trouble getting a stored procedure call to work in the same situation. So,
I was wondering if there is something special about how the stored
procedure or the call needs to be set up or if maybe we need a different
middleware tool.
</Dave Clark>
Stored procedure support was made for a customer, who needed it for Oracle.
The diffrence between Oracle and MS SQL is, that MS SQL doesn't support
inout parameters (and at the moment ArdGate expects all parameters to be
inout). If you don't need more than one output parameter, you could use a
function as a workaround. I will take your post as a RFE for ArdGate and a
future release of ArdGate will enhance stored procedure calls to MS SQL. If
you need this feature rather quick, priority could be influenced by a little
bit of sponsoring.
Dieter Bender
Author of ArdGate
As an Amazon Associate we earn from qualifying purchases.
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
