Bingo
THAT was it
I removed ALL the 'value' from the parameter inputs
Dropped and created the function and re-ran my test - and it worked
MUCH appreciated for all the responses
Now to make sure that everyone knows what I need to do - recompile everything
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: Alan Shore
Sent: Tuesday, January 09, 2018 2:40 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Creating an SQL function from a service program
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
midrange.com
