Trigger for limiting the row count of a table

Prasanthhere · Active User Joined: 03 Aug 2005 Posts: 306

Hi ,

Is it possible we can limit the row count of a table using trigger. Suppose I have a table in which I do not want more than 100 records . When 101 is tried to be inserted to that table it should throw a signal Record Overflow . Is it possible??

dbzTHEdinosauer · Posted: Fri Nov 13, 2009 7:01 pm

As a very simple answer to a very broad question - yes.

The INSERT Trigger would be activated after each insert,
the trigger would be a simple COUNT(*)
and when COUNT(*) > 100
then signal.

The signal (which would be a negative sql code) would inhibit the insertion of the 101st ROW.

by the way, every DB2 Vsn? SQL Reference & the DB2 Vsn? Application Programming and SQL Guide
has chapters devoted to Triggers.

If you start using proper terminology, you searches will be more successful.