Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Defining Variables in SQL Statements
Database Interface Designer Reference Guide
46
To specify values in the Define Variables dialog box
1 In the Navigator, select the variable to which you want to add one or more
values.
2 From the Query menu, select Define Variables.
The Define Variables dialog box appears, listing all the variables in the .mdq
file.
3 In the Value field, enter a value for each variable and click OK.
Note The pseudo values are stored in the .mdq file and can only be changed in the
Define Variables dialog box. Also, if the variable you are defining is a text string,
you must enclose the value in single quotation marks.
To delete a variable
When a variable is removed from a query statement that was previously defined in
the Database Interface Designer, the variable is automatically deleted from the
Navigator and no longer displays.
Specifying the Values at Runtime
Even though you have specified pseudo values for the defined variables using the
Database Interface Designer, they are only substitution values that are not
referenced at runtime. Values must be provided for the variables at runtime;
otherwise, the SQL statement will be syntactically invalid.
The correct value for each variable is specified at run time using the Variable
adapter command (
-VAR) in the Input Source - Override execution command