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

Unfortunately, I'm in serious deadline crunch right now, so I don't really
have the time so piece meal something to you guys.
But, I will, because I'd really like to resolve this.

And to answer your first question, that I had gotten so frustrated with
the UFD program, thinking perhaps it was a
signature program to the UDF, that I changed the code to call a different
UDF with no params, but was still
getting the problem.

Thanks,
David

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

www.dancik.com



"DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/30/2010 02:51 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)...






WAG: Just wondering if your stored proc uses CHAR parms? I've stumped
myself with this too many times. SQL tends to consider character
strings as VARCHAR, so when you search the stored proc catalog, it's
looking for a procedure definition that supports the VARCHAR type.

You never showed us the stored procedure definition...

-Eric

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of dmosley@xxxxxxxxxx
Sent: Sunday, August 29, 2010 1:50 PM
To: RPG programming on the IBM i / System i
Subject: RE: RPG - CLI SQL problem. (Where's my stored functions)...

Dennis, trust me, I have been around the barn and back. And it just
won't work and it makes NO sense.
The odd things are 1) I actually got it to work for about 10 minutes,
then
something messed it all up. And of course I have no idea what it was.
2) I 100% can see the library list has changed JUST before I execute the

SQL, and everything is in there that is needed, but yet
it still won't work.

Believe me, I'm very aggravated that it won't work. Because it is very

slick. I didn't flush the entire project away,.
I still have the CLI stuff in place, it's just that when a UDF is
needed,
I have to resort back to good 'ole reliable RPG/SQL.

Thanks again
David

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

www.dancik.com



"Dennis Lovelady" <iseries@xxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/29/2010 02:40 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)...






Seems a shame to scrap an approach you've been working on so hard, just
because of a minor limitation (a misunderstanding in concept, really).
If
you've already done substantial development (and it sounds like you
have),
wouldn't it make sense to build a function that would:

> Set userID
> Get user's job description name
> Get library list from job description
> Set library list

... all in one step? Then, couldn't you plug that function in where
you're
currently just setting the server User ID? And you'd be all set, right?

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"We have a firm commitment to NATO, we *are* a part of NATO. We have a
firm
commitment to Europe, we *are* a part of Europe."
-- former US Vice President Dan Quayle

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.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.