Re: SQL: Using restrict when dropping function and stored

Hey Sue,

Just to confirm: I have just tested it and tt works exactly as you say ..
again thanx

On Mon, Aug 31, 2020 at 7:39 PM Peter Dow <petercdow@xxxxxxxxx> wrote:

Rob,

Try it with RESTRICT on your drop function.

On 8/31/2020 10:17 AM, Rob Berendt wrote:

So if I do this:

create function rob.a () returns int
begin
return 1;
end
Function A was created in ROB.

create function rob.b () returns int
begin
return rob.a();
end
Function B was created in ROB.

I shouldn't be able to do this:
drop function rob.a
DROP FUNCTION statement complete.

But I can.

Rob Berendt

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com