I'd like to create trigger on a table.
I have table named CUSTOMER having columns
My aim is to create trigger on table so that
if CO_HONUM is 994422114330 in row, I'd like that record to be not inserted in a table.
This topic has been locked.
1 reply Latest Post - 2012-09-19T11:37:09Z by rmantyla
Pinned topic Trigger on Insert
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-09-19T11:37:09Z at 2012-09-19T11:37:09Z by rmantyla
rmantyla 270005PEBG4 PostsACCEPTED ANSWER
Re: Trigger on Insert2012-09-19T11:37:09Z in response to SystemAdminHi,
here is an example.
CREATE TABLE C_INFORMATION (
"CREATE TRIGGER TRIGGER_CHECK_C_HONUM ON C_INFORMATION
REFERENCING NEW C_HONUM AS NEW_C_HONUM
IF NEW_C_HONUM = '994422114330' THEN
RETURN SQLERROR 'Error in TRIGGER_CHECK_C_HONUM ';
insert into C_INFORMATION values (2, 'John', 'Smith', '1', '994422114330', 'Los Angeles', 'USA');
SOLID Procedure Error 23518: User error: Error in TRIGGER_CHECK_C_HONUM