Re: Accessing Service Programs from .NET

On 11/11/05, Fisher, Don <dfisher@xxxxxxxxxxxxx> wrote:
> I've been playing with UDTF's, too and haven't had much luck.  It keeps
> telling me the function isn't found (see below).
> create function AFUNCTION
> (Parm1 CHAR (10), Parm2 CHAR (1),
> Parm3 CHAR (10), Parm4 CHAR (7),
> Parm5 CHAR (100)) RETURNS dec (4,0)
> language RPGLE is DETERMINISTIC
> NO SQL EXTERNAL NAME 'MYLIB/MYPGM(AFUNCTION)'

declare the parms as VARCHAR.

-Steve

>
> select AFUNCTION('PARMVALUE', 'Y', ' ', ' ', ' ') from sysibm/sysdummy1
>
> The service program exists and the function exists in the service program.
> What am I missing?
>
> Thanks.
>
> Donald R. Fisher, III
> Project Manager
> Roomstore Furniture Company
> (804) 784-7600 extension 2124
> DFisher@xxxxxxxxxxxxx
>
> <clip>
> An alternative might be using UDTF (user defined table functions), but
> Creation and calling UDTFs are quite different from calling STORED
> PROCEDURES.
> <clip>
> --
> 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.
>
>