Fortinet FortiDB - Manual (Page 31)

User-Defined Rules User-Defined Rules by RDBMS
FortiDB Version 3.2 Privilege Monitor User Guide
15-32000-81364-20081219
29
end
SQL Procedural Language User-Defined Rules (DB2)
Adding a Procedural SQL Rule
Example
select count(*) from mytable;@
begin atomic
declare i int;
set i = 100;
if i > 1000 then
signal sqlstate 'IPERR' set message_text = '
Something is \
1
wrong';
end if;
insert into mytable values(10);
end@
select count(*) from mytable;@
Note: FixPak 4 for DB2 UDB 7.2 AIX client must be installed in order to support
this feature.
1. Line continuation symbol that is not actually keyed.