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

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-