RE: RPG Cross-Platform to SQL Server -- RPG400-L

FWIW, I use "call" to execute MS SQL Server SP's using JDBCR4 and the jTDS driver.

-----Original Message-----
From: dlclark@xxxxxxxxxxxxxxxx [mailto:dlclark@xxxxxxxxxxxxxxxx]
Sent: Friday, December 16, 2016 10:07 AM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Subject: Re: RPG Cross-Platform to SQL Server

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 12/16/2016 10:52:52
AM:

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 12/16/2016
02:37:40
AM:

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

inout).

It is true that MS SQL Server doesn't support the INOUT
keyword,

but a stored procedure parameter declared with the OUTPUT keyword can
still be used as an INPUT parameter by default. We have already
proved this here that this works. So, I don't know why either ARDGATE
or the SourceForge MS driver would have a problem calling a MS SQL
stored procedure with one parameter which is both input and output capable.

Now, I will say that MS SQL Server doesn't use the CALL keyword for invoking stored procedures. Rather, it uses the EXEC keyword -- but I still have to specify the CALL keyword from an embedded SQL point of view.
Is this the real source of the issue?

Sincerely,

Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331

Sincerely,

Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331

*********************************************************************************************

This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or
proprietary

information. If you have received this message in error, please
immediately notify the sender and delete and destroy the message and
all

copies. All unauthorized direct or indirect use or disclosure of this
message is strictly prohibited. No right to confidentiality or
privilege

is waived or lost by any error in transmission.

*********************************************************************************************

--
This is the RPG programming on the IBM i (AS/400 and iSeries)
(RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link:

http://amzn.to/2dEadiD

*********************************************************************************************
This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or proprietary information. If you have received this message in error, please immediately notify the sender and delete and destroy the message and all copies. All unauthorized direct or indirect use or disclosure of this message is strictly prohibited. No right to confidentiality or privilege is waived or lost by any error in transmission.
*********************************************************************************************