Use the Variables tab to assign substitution variables for selection criteria or SQL statements in an Access Definition. Additionally, you can use any defined variables when creating Extract or Restore Archive Actions.
For detailed information about selection criteria, SQL, or Archive Actions, refer to Table Specifications.
By assigning variables, you provide values for the variables each time the Access Definition is processed. As an option, you can provide default values for substitution variables. The variables are saved with the Access Definition.
Enter a name for the variable (1 to 12 characters). The name is embedded in the selection criteria or SQL. Logical naming conventions help identify variables.
Enter an optional default value for the variable to be used when no value is specified for the variable at run time.
Default values must be of the appropriate data type and size for the column and must conform to SQL syntax. For example, assume a variable name is ST (state), the variable delimiter is a colon ( : ), and the column requires character data.
Selection Criteria | Value |
---|---|
= ':ST' | CA |
Selection Criteria | Value |
---|---|
= :ST | 'CA' |