× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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-

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.