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

[dmosley@xxxxxxxxxx]

Hey Vern, does this look familiar?  I am having the same problem you had 4 
years ago.

http://archive.midrange.com/midrange-l/200609/msg01464.html 

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

www.dancik.com 



Vern Hamberg <vhamberg@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/28/2010 02:14 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

I really don't think that the initial library list setting in a JOBD is 
uses when the job has already started. You say you also have the CGI 
environment variable for the library list - that is probably what is 
doing the change. Again, the documentation on QSTSETP says that nothing 
is changed except for using authority of the new user.

Now I haven't tested this recently - we use the Apache server with one 
of our products and have had to look at this stuff - you might try 
changing the library list in that user's jobd to something different 
from the value of the environment variable. Then recycle the server and 
see which library list you get. I'm curious. I've seen the Apache web 
server do some interesting things that I'd not expected.

Vern

On 8/28/2010 12:23 PM, dmosley@xxxxxxxxxx wrote:
> My understanding of the ServerUserId, is that the profile we have it 
being
> changed to has a
> job description associated to it, which when changed, changes the 
library
> list.  We have done
> Net.Data stuff for years (years ago), and then from there merged more 
into
> Java/Web development..
> So, I haven't had to do much Apache config, in a while, except for 
simple
> JKMount, for java/war connections.
> I may be wrong about the ServerUserId, but it makes sense.
>
> I'll try taking the ServerUserId attribute out, to see if it is 
confusing
> the server.  Hopefully your right about that.
>
>
> How I was debugging was that I'd put the QTMH* job in STRSRVJOB mode, 
then
> STRDBG the program I was calling.
> Then flip to another session to see the library list.
>
>
> dav
>
> David L. Mosley, Jr.
> Technical Solutions Architect
> Dancik International, Ltd.
> 2000 CentreGreen Way, Suite 250
> Cary, NC 27513
>
> www.dancik.com
>
>
>
> Vern Hamberg<vhamberg@xxxxxxxxxxx>
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 08/28/2010 10:08 AM
> 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, Dennis
>
> ServerUserID and UserID can make the HTTP server jobs run under users
> other than the default QTMH* users. Swapping profiles is what is done.
>
> I agree that the library list is not changed by swapping profiles - here
> is some info from the QWTSETP API doc -
>
> The Set Profile Handle (OPM, QWTSETP; ILE, QsySetToProfileHandle) End of
> changeAPI validates the profile handle, locks the user profile, and
> changes the current thread to run under the user and group profiles
> represented by the profile handle. Once the change has been made, any
> open files and objects allocated by the original profile are accessible
> to the new profile.
>
> No other attributes associated with the user or group profile are
> replaced.
>
> I suspect that the use of the environment variable along with swapping
> profile is confusing the issue - the former is making the library list
> change, the latter changes the user.
>
> Now there is still the issue of finding stored procedures - and one of
> the SQL manuals - I forget - discusses how these are found. It is not
> always obvious, it seems.
>
> Vern
> -snip-