Re: Using Triggers and Sequences

From: Russell Fray <russ_at_u-net.net>
Date: 1998/03/24
Message-ID: <3517C4F3.670A99FF@u-net.net>#1/1

Mark Powell wrote:
>
> Hi there,
>
> Having a few problems when trying to create a trigger.
>
> I'm creating the trigger to try and make an autoincrement type field, it
> expects a record to be insert or updated on the table "E_SUB" and is
> supposed to alter the field "AG_NUM" if the value is "0".
>
> The sequence seems to be okay...
>
> CREATE SEQUENCE USER.S_AG_NUM INCREMENT BY 1 MAXVALUE 999999 MINVALUE 90000
> NOCYCLE CACHE 20 ORDER;
>
> The trigger....
>
> Any help would be gratefully appreciated (as I'm pulling my hair out!)

Try cutting your hands off. Received on Tue Mar 24 1998 - 00:00:00 CST