Thanks Alan for the response, but once again, that is an SQL function.
SQL functions and SQL External Procedures are not the same thing.
Robert Newton
EDPS
Electronic Data Processing Services
Software Engineer
rnewton@xxxxxxxxxxxxxxxxx
This communication is confidential and is intended to be privileged. If
there is a problem with this transmission, please contact the sender. If
the reader of this message is not the intended recipient, or the employee
or agent responsible to deliver it to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
"Alan Campin"
<Alan.Campin@Exot
icMetals.com> To
Sent by: <rpg400-l@xxxxxxxxxxxx>
rpg400-l-bounces@ cc
midrange.com
Subject
Re: Wrap an RPG Procedure with an
11/27/2007 01:06 SQL External Procedure
PM
Please respond to
RPG programming
on the AS400 /
iSeries
<rpg400-l@midrang
e.com>
<snip>
I have searched the archives, google, and IBM docs but have not been
successful in finding information on how to call an RPG service
program's
procedure that returns a value, from within an SQL external procedure.
Has
anyone ever found any mention of this anywhere? Is it possible, or do I
have to change my service programs to use inout parms rather than
returning
a value just so that I can wrap it with an SQL proc?
</snip>
You will find a complete example of a SQL Function returning a value at
http://www.think400.dk/downloads.htm. Look for iDate six items down.
--
This is the RPG programming on the AS400 / 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.
midrange.com
