|
See Also
The following examples show
the USoft Rule Language syntax and equivalent SQL for simple
constraints.
Simple Conditional
Constraint
|
USoft Rule Language
|
SQL Equivalent
|
|
FOR
drivers
DO NOT ALLOW THAT age
< 23
|
select ''
from driver
where age < 23
|
Simple Corrective
Constraint
|
USoft Rule Language
|
SQL Equivalent
|
|
FOR
drivers
MAKE SURE THAT
status = 'Accredited'
WHERE
age > 23
or
license_date > sysdate - (3 * 365)
|
update driver
set status = 'Accredited'
where age > 23
or
license_date < sysdate - (3 * 365)
|
|
