Re: Overloaded UDF

Not quite.

You'd need more than one RPG procedure.

Charles

On Tue, Dec 1, 2009 at 3:55 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:

Not sure why you would need to do that. SQL will do the work for you and
calls the proper procedure based on the parameters that you enter. Just
create two procedures and register them with SQL and it will call the
correct procedure for you.

For further information look at www.think400.dk/downloads.htm and look

for

iDate.

On Tue, Dec 1, 2009 at 1:46 PM, sjl <sjl_abc@xxxxxxxxxxx> wrote:

I have created an SQL UDF using RPG code that accepts two parameters,

and I

want to add an optional third parameter.

As a test, I added an optional third parameter to the sub-procedure in

the

service program (and created the function again using the same name

except

with 3 parms), thinking that I could check to see how many parms are

being

passed to the RPG program by examining the value of %PARMS. However,
%PARMS
is -1, regardless of the number of parms that I pass via my UDF call
(either
2 or 3).

As a Q&D fix, I used a Monitor block when referencing the 3rd parm, but

I

would like to understand what is really happening under the covers.

Code snippet here: http://code.midrange.com/d072fb0fec.html

Regards,
sjl



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