Hey guys, I appreciate all your feedbacks and candor.
After Vern post last night, I ended giving up on the use of UDF, in my CLI
statements (due to a deadline on Tuesday).
I am sure you guys are 100% accurate on the use of ServerUserId (not
changing the library list). As I had said,
we used to use alot of Net.Data with Direct-Calls to RPG programs, and
relied on ServerUserId when the application
was NOT password protected. We did this (instead of assigning the QTMH*
job with job descriptions or library lists),
because our software is used companies with multiple environments, and
needed a library list established. And
ServerUserId appeared to tackle this need.
But, anyway, thanks again for the assistance. It's still strange to me
that these UDF don't work.
BUT, I can cross that bridge again, when I need to.
thanks again
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/29/2010 01:21 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'm afraid to say anything for fear that I might be wrong... I can't
pretend that I've mastered every aspect of Apache on IBM i. But, there
are some big discrepancies between my understanding and what you're
saying... Here's my understanding:
ServerUserId = UserID that the *server* runs under. Dft=QTMHHTTP
UserId = UserID that CGI programs run under. Dft=QTMHHTP1 can be set to
a profile, or to special values %%CLIENT%% and %%SERVER%%
The QIBM_CGI_LIBRARY_LIST variable can be set to override the default
library list. You told me on 8/28 that you were setting this. If
that's the case, the values of the ServerUserId and UserId variables are
utterly irrelevant, except from the perspective of whether the user has
authority to what was specified in QIBM_CGI_LIBRARY_LIST.
Even if I'm misunderstanding, and you're not really setting
QIBM_CGI_LIBRARY_LIST, the value of ServerUserId is irrelevant, because
CGI programs don't run under ServerUserId. Only the server does! They
run under UserId -- though, ServerUserId would become relevant if the
UserId is set to %%SERVER%% -- but that would be (IMHO) an extremely
weird configuration.
And finally -- and this is where I'm not confident of my knowledge -- I
don't _think_ it uses the library list from either the ServerUserId or
the UserId. I think those only establish the profiles, not the library
list.
But even if I'm wrong about that -- the odds that the ServerUserId is
impacting the library list seems extremely slim... Which makes me think
you're following a red herring.
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.
midrange.com
