Rules Syntax
The following table describes the syntax rules to use in expressions.
Syntax | Rule |
Names | Use the physical names of columns and tables. Column and table names are case sensitive. |
Dates | Enter dates in 24 hour format: YYYY-MM-DD HH:MM:SS. Enter the system date as %SYSDATE%. |
Syntax | ![*](bullet.gif) Embed expressions inside % sign. For example, if the table name is Employee and the column name is Emp_Name, the expression is %Employee.Emp_Name%. ![*](bullet.gif) Characters are treated as literal in string comparisons. Comparing two numeric columns may result in a validation error. For example, where column A = 2 and column B = 100, the rules engine evaluates column B as greater than column A because, starting with the first character, 1 (in 100) is less than 2. |
Operations | ![*](bullet.gif) You can use a combinations of table names, column names, system date, characters, and dates in an expression. ![*](bullet.gif) You cannot compare columns from more than one table. ![*](bullet.gif) You can create multiple expressions, but logical operators, such as parentheses, are not allowed. ![*](bullet.gif) The ASSIGN operator is only valid in THEN expressions. |