Description
noneTrigger properties
| name | value |
|---|
| name | JESSE.MIN_SALARY |
| base object type | |
| parent | STAFF |
| type | |
| event | |
| action type | |
| referencing names | |
| status | |
| description | |
Dependency graph
Objects that JESSE.MIN_SALARY depends on
| name | object type | level |
|---|
| STAFF | table | 1 |
Code
CREATE TRIGGER min_salary NO CASCADE BEFORE INSERT ON staff REFERENCING
NEW AS newstaff FOR EACH ROW MODE DB2SQL BEGIN ATOMIC SET newstaff.salary
= CASE WHEN newstaff.job = 'Mgr' AND newstaff.salary < 17000.00 THEN 17000.00
WHEN newstaff.job = 'Sales' AND newstaff.salary < 14000.00 THEN 14000.00
WHEN newstaff.job = 'Clerk' AND newstaff.salary < 10000.00 THEN 10000.00
ELSE newstaff.salary END; END;