RPG - CLI SQL problem. (Where's my stored functions)...

[dmosley@xxxxxxxxxx]

I am performing SQL reads and fetches using the CLI SQL functions, in RPG.
Everything works wonderfully, except for the fact that it is have the 
worst time reading
my SQL stored functions.   It keeps telling me not found.  I know that 
that message can
be misleading, and yes, I have checked the signature of the function to my 
actual execution, 
and they make.

I am connected via SQLConnect, using *LOCAL, and null user and profile 
(which to my understanding
will make the default job settings like library list default for the 
SQLConnect).

Any ideas would be greatly appreciated.  Of course there are always work 
arounds like not using
the CLI stuff (haha), but the structure that I have is very slick and very 
dynamic, it would be a shame
to ugly it up just because stored functions won't work.

Thanks in advanced,
David

David L. Mosley, Jr.
Technical Solutions Architect
Dancik International, Ltd.
2000 CentreGreen Way, Suite 250
Cary, NC 27513

www.dancik.com