Table 132 Examples of Database Variable Reference Statements
Variable |
What the Variable Represents |
---|---|
DB_ACCOUNTING.TOTALEXP |
The total expenses of the accounting department (current value). |
DB_MARKETING.TOTALEXP |
The total expenses of the marketing department (current value). |
DB_TOTALEXP |
The total expenses of a department (current value). The group is determined by the group of the rule at execution time. |
DB_MARKETING.TOTALEXP@G1 |
The previous total expenses figure of the marketing department. |
DB_MARKETING.TOTALEXP@D000101 |
Total expenses figure for the marketing department for 01/01/00. |
DB_TOTALEXP@RDAILY |
The total expenses figure of the current group with a run identifier of DAILY. |
%%DB_ACCOUNTING:TOTALEXP@G1 |
The previous total expenses figure of the marketing department, which is resolved using AutoEdit substitution. The period separator is replaced by a colon separator. |
Parent Topic |