Re: Creating an SQL function from a service program

[Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>]

"My stupidity amazes even me sometimes"

Don't beat yourself up.  We've all been there.

My boss is fond of saying "you don't know what you don't know".



On Tue, Jan 9, 2018 at 2:39 PM, Alan Shore <ashore@xxxxxxxx> wrote:

> Ahhh -$%^&*
> I just realized that you were talking about the service program
> I was looking at the create function and could NOT determine what the @#$$
> you were talking about
>
> My stupidity amazes even me sometimes
>
> Let me try that
>
> Question
> If that is in fact the answer - does that mean that any program using that
> procedure needs to be re-compiled?
>
>
>
> Alan Shore
> E-mail : ASHORE@xxxxxxxx
> Phone [O] : (631) 200-5019
> Phone [C] : (631) 880-8640
> 'If you're going through hell, keep going.'
> Winston Churchill
>
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Kevin Adler
> Sent: Tuesday, January 09, 2018 2:35 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: RE: Creating an SQL function from a service program
>
>    Alan, did you remove the "Value" keyword from the PI? I'm pretty sure
> that
>    SQL will only pass arguments by reference/pointer, not by value.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD