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

[dmosley@xxxxxxxxxx]

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.