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

hi David,

Are you setting SQL_ATTR_DBC_SYS_NAMING? If so, it'll use your library list to locate your functions (unless explicitly qualified)

Or are you using SQL naming? (If so, I it searches the SQL PATH.)

Make sure your *LIBL or PATH includes the functions that it can't find. (Not the programs behind them, but the actual functions.) Also, if you're using a server job, make sure the *LIBL is set on the server job rather than on your local job.

HTH


On 8/27/2010 4:08 PM, dmosley@xxxxxxxxxx wrote:

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