USoft Rule Language Examples: Simple Constraints

Previous Next

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