RE: Calling a remote program...

SQL can remotely call a program, and supports in-out parameter
passing... This method DOES require authentication for the SQL CONNECT
statement, so there could be extra work to support this.

-Eric

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Robert Rogerson
Sent: Tuesday, May 04, 2010 3:32 PM
To: RPG programming on the IBM i / System i
Subject: Re: Calling a remote program...

Yes Jerry, I did consider this. The problem is, as I understand it, I
can
not return pararmeters which I did specify as a requirement (The program
requires 6 input parameters and outputs 3 parameters.)

Thanks,

Rob

On Tue, May 4, 2010 at 3:27 PM, Jerry Adams <Jerry@xxxxxxxxxxxxxxx>
wrote:

RUNRMTCMD. From LPar-A one could call a program in LPar-B (or any

system

to which one can make a connection). The program object must exist in
LPar-B (in this illustration).

Jerry C. Adams
IBM System i Programmer/Analyst
--
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx

Honest businessmen should be protected from the unscrupulous consumer.

-

Lester Maddox


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx

[mailto:rpg400-l-bounces@xxxxxxxxxxxx]

On Behalf Of Robert Rogerson
Sent: Tuesday, May 04, 2010 1:11 PM
To: RPG programming on the IBM i / System i
Subject: Calling a remote program...

We have an LPAR'd where our ERP applications and our warehouse reside

on

two
separate partitions. I have a requirement to call the same program

(for

example TestRules) from both applications. In the past this was

handled by

having so the source and object on both boxes. This lead to the

problem of

keeping the source and objects consistent. We have no change

management

software (I know...) so it has been up to the programmers to keep
everything
the same.

What other methods are recommended for calling a program on another
partition. I think a stored procedure is what I'm looing for but I

wanted

additional input. The program required 6 input parameters and outputs

3

parameters.

Any input is greatly appreciated.

Rob
--
This is the RPG programming on the IBM i / System i (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.

--
This is the RPG programming on the IBM i / System i (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.