You were :)
I misread your post.
Sorry,
Charles
On Tue, Dec 1, 2009 at 4:18 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:
Thought that was what I was saying.
On Tue, Dec 1, 2009 at 2:12 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
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.
--
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.
