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

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

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