Previous Topic

Next Topic

Book Contents

Book Index

Examples of Database Variable Reference Statements

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

Variable Generation Attributes