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