Click the [+] button at the bottom of the
Contexts view to add lines in the table.
Click in the Name field and enter the name of the
variable you are creating.
Name the first variable host for this example.
From the Type list, select the type of the variable.
Warning: If you change the type of a variable that has already a value, the value will be cleared and you need to set it again.
- If needed, click in the Comment field and enter a comment to describe the variable.
Click in the Value field and enter the
variable value under each context.
For different variable types, the Value field appear slightly different when you click in it and functions differently:
Type Value field Default value String (default type) Editable text field null Boolean Drop-down list box with two options: true and false Character, Double, Integer, Long, Short, Object, BigDecimal Editable text field Date Editable text field, with a button to open theSelect Date & Time dialog box. File Editable text field, with a button to open the Open dialog box for file selection. Directory Editable text field, with a button to open the Browse for Folder dialog box for folder selection. List of Value Editable text field, with a button to open the Configure Values dialog box for list creation and configuration. (Empty) Password Editable text field; text entered appears encrypted. Resource Editable text field, with a button to open the Select a Resource dialog box for you to select a resource defined under Resources in the Repository.
For more information, see Using resources in Jobs.Warning: Be sure to enclose the value of a string type of variable between double quotation marks if it has a leading and/or a trailing double quotation mark as part of the variable value. In any case, it will do no harm if you enclose the values of string type of variables between double quotation marks.
If needed, select the check box next to the variable of interest and enter the
prompt message in the corresponding Prompt
This allows you to see a prompt for the variable value and to edit it at the execution time. You can show/hide a Prompt column of the table by clicking the black right/left pointing triangle next to the relevant context name.
Repeat the above steps to define all the variables for the different
- port, type String,
- database, type String,
- username, type String,
- password, type Password,
- table_name, type String.
All the variables created and their values under different contexts are displayed in the table and are ready for use in your Job. You can further edit the variables in this view if needed.
You can also add a built-in context variable to the Repository to make it reusable across different Jobs. For more information, see Adding a built-in context variable to the Repository.