RE: SQL procedures and functions

The function is written in SQL and is generated via the RUNSQLSTM using a source member in QSQLSRC. There isn't a program.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Tuesday, January 21, 2025 3:05 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL procedures and functions

CREATE PROCEDURE
" If the PROGRAM NAME clause is provided, its name is used for the creation of the program object. Otherwise, the SPECIFIC procedure name is used as the name of the member in the source file and the name of the program object, if it is a valid system name. "
https://www.ibm.com/docs/en/i/7.5?topic=statements-create-procedure-sql


On Tue, Jan 21, 2025 at 2:28 PM <smith5646midrange@xxxxxxxxx> wrote:

When I do an SQL "create or replace function_name" is there a way to
specify what I want the 10 character name to be?



For example, if I create a function named Calculate_Totals, the system
name of the *SRVPGM is CALC000001. I would like to have it named
CALCTOTALS so it is reasonably close to the function name.



Is that possible?



--
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.

--
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.