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

[dmosley@xxxxxxxxxx]

I am setting the "SQL_ATTR_DBC_SYS_NAMING" attribute, and it allows me to 
access service programs
and execute normal SELECT sql statements, (as long as they don't include 
my functions).

My Apache config includes a ServerUserID, which (I thought) is supposed to 
set the library list
when accessed.

It's just a odd mystery why this isn't working.

Thanks
David


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

www.dancik.com 



Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/27/2010 05:29 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
cc

Subject
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