Defines variables. Variables can be used to dynamically control script execution. You can store different types of values in variables. The syntax is:
Syntax
VAR[Variable name][Variable value]
Parameters
Variable name
The name of the variable. Use descriptive names.
Variable value
The value of the variable. The values can be of any type.
To reference a variable use the following syntax:
%VAR%
How to use a variable
1 In Main file, choose New. In the list of transformation instructions, choose VAR. Variable appears.
2 In Name, type the variable name, as shown in Figure 5‑56. In Value, type the variable value. In this example, the variable contains the name of a table.
Figure 5‑56 Creating a variable
3 In Variable, choose OK. Variable appears in Main file.
4 In Main file, choose New. In the list of transformation instructions, choose EXPESSION. Expression appears.
5 In Table, select a database from the drop-down list, and type the following expression in the table box, as shown in Figure 5‑57:
[%TABLE%]
Figure 5‑57 Using a variable
6 In Column, type the name of the new column.
7 In Expression, type the expression for calculating the value of the new column. Use the variable reference where needed.
