Skip to Content
0
Jul 20 at 06:46 AM

HANA 2.0 Limit amount of rows per column value

104 Views

Dear community,

i would like to limit the amount of rows that can be inserted into a hdbtable depending on the values that are inserted.

Simple example:

Table
{
 ID : UUID,
 TYPE : VARCHAR(50)
}

On insert i would like to check if the type beeing inserted already exists n times. Meaning if my limit is say 10 entries of the same type the insert should fail.

Hope this is an easy one for the experts.

Cheers