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)
|
See Also
USoft Rule Language
|