Re: Resolving *SRVPGM for ext stored proc

Yes. but....
1. I believe that if in the CRTSQLRPI you do not specify *SYS as part of
the OPTIONs where you see *XREF, it defaults to SQL and if
SQLPATH(*NAMING) is specified, the SQLPATH will take the SQL value. I
suggested you use both values: *SYS in OPTION and SQLPATH(*LIBL).
2. In the CREATE OR REPLACE PROCEDURE there is an option that you have to
include like "SET OPTION NAMING = *SYS" along with other options.
3. Try to connect from the outside interface with a user profile that has a
job description that includes those libraries, where the external sprocs
are defined.
4. In the connection string, there is also something similar to
"NAMING=*SYS" or so, see the .NET or Java documentation.
5. LANGUAGE has to be "RPGLE".

Not sure either, but if you use a service program, I think I remember that
the EXTERNAL NAME must include the library, or else it does not accept
*LIBL.
i.e. EXTERNAL NAME 'MYLIB/MYSRVPGM(MYROUTINE)'.

If I am wrong with anything, please someone let me know. I got rid of all
these kinds of issues by standardizing like this, so I do not remember
exactly what I had to face but I could resolve them.

HTH.
JS

El jue, 19 mar 2026 a las 7:05, Justin Taylor (<jtaylor.0ab@xxxxxxxxx>)
escribió:

Where is naming specified in stored proc creation?



The service pgm was compiled with SQLPATH(*NAMING).




On Thu, Mar 19, 2026 at 2:37 AM Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

What naming conventions were used when generating the stored procedure?
Even though the environment uses *SYSTEM naming conventions, it the

stored

procedure was created with *SQL Naming conventions, it will run with SQL
Naming conventions (independent of the naming conventions used in the
environment)

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i
Database and Software Architect
IBM Champion since 2020

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training

them

and keeping them!"
"Train people well enough so they can leave, treat them well enough so

they

don't want to. " (Richard Branson)
"Learning is experience … everything else is only information!" (Albert
Einstein)

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.