RE: distributed SQL calling RPGLE on a remote box

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

This is what I used in my test application for remote program calls vie SQL....

C/Exec SQL                                       
C+   Connect to XYZ01                            
C/End-Exec                                       
C                                                
C/Exec SQL                                       
C+   CALL TESTED/METAPHONE (:$Input, :$Output)   
C/End-Exec                                       
C                                                
C/Exec SQL                                       
C+   DISCONNECT CURRENT                          
C/End-Exec      

Worked like a champ...
Eric                                 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Jeff Day
Sent: Friday, May 04, 2007 4:12 PM
To: midrange-l@xxxxxxxxxxxx
Subject: distributed SQL calling RPGLE on a remote box


I've scanned the archives, and google, and am having trouble finding
answers or examples.
 
I am using SQL 'connect to' to connect to other System i's, and I need
to call an RPGLE program on the remote boxes, before I issue queries.  I
am looking for a method I can use between /Exec SQL - /End-Exec.
 
Distributed SQL docs say "CALL" should work, and I found an archive
email from Charles Wilt that said you don't need a stored procedure to
do it either... but I can't seem to get it to work yet.
 
If anyone could share a code example, I'd greatly appreciate it.
 
Thanks,
Jeff


**********************************************************************************************
If the reader of this email is not the intended recipient(s), please be advised 
that any dissemination, distribution or copying of this information is strictly 
prohibited. Johnson Matthey PLC has its main place of business at 2-4 Cockspur 
Street, London (020 7269 8400). Whilst Johnson Matthey aims to keep its network 
free from viruses you should note that we are unable to scan certain emails, 
particularly if any part is encrypted or password-protected, and accordingly 
you are strongly advised to check this email and any attachments for viruses. 
The company shall NOT ACCEPT any liability with regard to computer viruses 
transferred by way of email.

Please note that your communication may be monitored in accordance with Johnson 
Matthey internal policy documentation.
**********************************************************************************************

This message has been scanned for viruses by MailControl - www.mailcontrol.com