Re: Calling a Pgm on a Remote i5 using RPG

Thanks a lot Matt, CRTSQLPKG did the trick....

Matt Haas wrote....
Did you create the stored procedure definition on the remote machine?
The program also has to be on the remote machine. You will also need to
create an SQL package for the program that is connecting to the remote
machine or it will not work. Here's an example:

CRTSQLPKG PGM(mylib/mypgm) RDB(remotedb) USER(user) PASSWORD(password)

The CRTSQLPKG command must be run on the local machine.

Additionally, if you enter STRDBG UPDPROD(*YES) and then run your
program, the job log will give you detailed information about what's
happening.



Regds
Sarvapriya
******************************************************************************

The information contained in this electronic communication and any
accompanying document is confidential, may be attorney-client privileged,
and is intended only for the use of the addressee. It is the property of
Ryder System, Inc. Unauthorized use, disclosure or copying of this
communication, or any part of it, is strictly prohibited and may be
unlawful. If you have received this communication in error, please notify
the sender immediately by return email, and destroy this communication and
all copies of it, including all attachments. Electronic communication may
be susceptible to data corruption, interception and unauthorized tampering
and Ryder disclaims all liability of any kind for such actions or any
consequences that may arise directly or indirectly therefrom.
******************************************************************************