Variable Name (-V)

Specify this parameter whenever needing variable name substitution in an SQL query that is contained in an MDQ file. The equal sign (=) must be included to properly associate the substituted value with the variable name.

-V name=value

whereby:

name is the name of the variable in the SQL query.

value is the value that should be substituted.

For example:

If using the following query from an .mdq file, select * from BigTable where Identifier=#ID# then specify the following option on the mtsmaker command line:

-V ID=2

In this way, the query to be executed would be as follows:

select * from BigTable where Identifier=2

Note that variable name values are read by default from the .mdq file, unless overridden on the command line.

See the Database Interface Designer documentation for more information regarding the definition of variables in SQL statements.