Re: Question on scalar EDFs

Signing off and back on, or disconnecting your connection and reconnecting,
likely will fix your issue. I've seen that symptom before and a disconnect
/ reconnect fixed it for me.

date: Thu, 29 Mar 2018 11:13:45 -0500

from: Booth Martin <booth@xxxxxxxxxxxx>
subject: Re: Question on scalar EDFs

I wonder if it heals if you sign off then back on?


On 3/29/2018 9:21 AM, a4g atl wrote:

I created a scalar UDF and it worked.
I created a view to include the scalar function.
I then modified the RPG program that was building the scalar function (
part description).
When I reran the SELECT on the view, it was using the original version

of

the RPG program.

I dropped and recreated the function, but this did not help.

I then dropped the VIEW and recreated it. This then displayed the

correct

scalar values in the description field.

Question: Is this how it should work? Do I need to DROP and CREATE the

view

each time I modify the program?

TIA

Darryl Freinkel

--
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