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-