Thanks Alan.
When I do that, I get the following:
SQL State: 42724
Vendor Code: -444
Message: [SQL0444] External program SORDERAPI in GNODGDF not found.
Cause . . . . . : An attempt was made to CALL procedure or invoke
function GETSHORTSKU in GNODGDF. External program or service program
SORDERAPI in schema GNODGDF was not found.
Someone else in my organization said they use question mark instead of
the out parameter, but I get the same result.
I know the service program is there, and it works when used from a
regular RPG calling program. Is there something special I need to do
with the CRTSRVPGM parameters when it is going to be used with an SQL
stored procedure ?
Greg
|-----Original Message-----
|From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
|bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
|Sent: Monday, September 10, 2007 6:08 PM
|To: midrange-l@xxxxxxxxxxxx
|Subject: Re: Syntax for calling stored procedure
|
|<snip>
|I got the message indicating that it was successfully created.
|
|Now the question. How do I call it ? Can I test this interactively
|from STRSQL or Iseries Navigator RUNSQL Scripts ?
|
|What's the correct syntax ?
|</snip>
|
|Use Run Sql Scripts in Ops Nav
|
|Call gnodgdf/getShortSKU ('SKU1', '001', '100', '3410')
|
|
|--
|This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
|To post a message email: MIDRANGE-L@xxxxxxxxxxxx
|To subscribe, unsubscribe, or change list options,
|visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
|or email: MIDRANGE-L-request@xxxxxxxxxxxx
|Before posting, please take a moment to review the archives
|at
http://archive.midrange.com/midrange-l.
midrange.com
