Triggers and Stored Procedures

[agrollma]

I need some basic help with getting a trigger and stored procedure working in IDS.

I have a database with category, product, size, primary. I can't force uniqeness, but I can only have one combination of category, product, size, and primary where primary is "Y". I can have multiple Ns. The rows can be populated like:

category product size primary
CAT1 PROD1 SIZE1 Y
CAT1 PROD1 SIZE1 N
CAT1 PROD1 SIZE1 N
CAT2 PROD1 SIZE1 Y
.
.
.
I need to allow users to add and update records, but need to make sure we always only have one record with category, product, size, and primary = Y. Can someone provide an example of a trigger and stored procedure (which is what I think I need to do here) to force this condition?

Thanks in advance,
ag