Stored Procedures and User Defined (Table) Functions both can be overloaded,
that means the multiple procedures or functions with the same name but
different parameter definition can coexist within the same library.
While for stored procedures only the number of parameters is compared, for
UD(T)Fs the data types of the parameters are checked. The length or size of
the parameters is not relevant.
That means it is not possible to have 2 procedures with the same name with a
single parameter defined as char while in the other procedure is defined as
decimal.
But it is possible to have 2 UD(T)Fs with a single parameter but a different
data type.
CHAR and VARCHAR are considered as different parameters.
When passing an character expression as parameter it is interpreted as
VARCHAR. That's why you have to cast the parameter into the expected data
type.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"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!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Michael Naughton
Gesendet: Thursday, 28.6 2012 23:44
An: Midrange Systems Technical Discussion
Betreff: Re: UDTFs in RPG - Parameters question
I just went through this article and created my first UDTF, and I agree --
this is great!
I do have one question, though. When I try to test it in iNav passing
literals, I have to define them. For example, this works:
SELECT * FROM TABLE(MYLIB/MYTESTUDTF(char('A',1),char('K',1))) AS XYZ
but this does not:
SELECT * FROM TABLE(MYLIB/MYTESTUDTF('A', 'K')) AS XYZ
instead, I get a "MYTESTUDTF in MYLIB type *N not found" error.
I'm curious, because when I call a stored procedure, I don't have to do that
-- for example, this works:
CALL MYLIB/MYTESTPROC('TESTVALUE',40,10,1,'C','*ALL')
Obviously, the UDTF treats passed parameters differently from the way the
stored procedure does, but does anyone know why? Is there a way to avoid
having to define literals passed to the UDTF?
Thanks very much,
Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA 01376
413-676-3144
Internal: x 444
mnaughton@xxxxxxxxxxxx
****************************************
NOTICE: This e-mail and any files transmitted with it are confidential and
solely for the use of the intended recipient. If you are not the intended
recipient or the person responsible for delivering to the intended
recipient, be advised that any use is strictly prohibited. If you have
received this e-mail in error, please notify us immediately by replying to
it and then delete it from your computer.
--
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
