Thanks everyone for the help.
For the archives, it turned out to be simpler than we thought.
When creating the procedure, everything needs to be in ALL CAPS.
That fixed it.
|-----Original Message-----
|From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
|bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
|Sent: Tuesday, September 11, 2007 9:42 AM
|To: Midrange Systems Technical Discussion
|Subject: RE: Syntax for calling stored procedure
|
|Is there a reason code with that SQL0444? You might have to look at
the
|joblog.
|
|Rob Berendt
|--
|Group Dekko Services, LLC
|Dept 01.073
|PO Box 2000
|Dock 108
|6928N 400E
|Kendallville, IN 46755
|
http://www.dekko.com
|
|
|
|
|
|"Fleming, Greg \(ED\)" <GFLEMING@xxxxxxxxxxxxxxxxxxxx>
|Sent by: midrange-l-bounces@xxxxxxxxxxxx
|09/11/2007 09:31 AM
|Please respond to
|Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
|
|
|To
|"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
|cc
|
|Fax to
|
|Subject
|RE: Syntax for calling stored procedure
|
|
|
|
|
|
|Thanks Rob.
|
|It is a single module service pgm, but not an SQLRPG. It contains no
|embedded SQL. So I just issue a CRTRPGMOD. So I just have a *Module
and
|a *SRVPGM object in my library.
|
|Greg
|
||-----Original Message-----
||From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
||bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
||Sent: Tuesday, September 11, 2007 9:05 AM
||To: Midrange Systems Technical Discussion
||Subject: RE: Syntax for calling stored procedure
||
||Perhaps you are on the right track. Maybe it is an "SQL Package"
|issue?
||
||If your service program is a single module service program and you
|issued
||the CRTSQLRPI to create the service program then the *SQLPKG object
|should
||have been created. If your service program is a multiple module
|service
||program you might have to issue the CRTSQLPKG separately.
||
||>From the help on OBJTYPE:
||When OBJTYPE(*PGM) or OBJTYPE(*SRVPGM) is specified and the RDB
||parameter is also specified, the CRTSQLPKG command is issued by the
||SQL precompiler after the program has been created. When
||OBJTYPE(*MODULE) is specified, an SQL package is not created and you
||must issue the CRTSQLPKG command after the CRTPGM or CRTSRVPGM
||command has created the program.
||
||Try WRKOBJ GNODGF/SORDERAPI. You should have two objects, a *SRVPGM
|and a
||*SQLPKG.
||
||Rob Berendt
||--
||Group Dekko Services, LLC
||Dept 01.073
||PO Box 2000
||Dock 108
||6928N 400E
||Kendallville, IN 46755
||
http://www.dekko.com
||
||
||
||
||
||"Fleming, Greg \(ED\)" <GFLEMING@xxxxxxxxxxxxxxxxxxxx>
||Sent by: midrange-l-bounces@xxxxxxxxxxxx
||09/11/2007 08:15 AM
||Please respond to
||Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
||
||
||To
||"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
||cc
||
||Fax to
||
||Subject
||RE: Syntax for calling stored procedure
||
||
||
||
||
||
||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.
||
||
||--
||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.
||
||
||--
||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.
|
|
|--
|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.
|
|
|--
|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
