A very powerful feature of QiD is the ability to use symbols through your SQL to generalise or parameterise code. For example, a database reference of {DB} can be used and the value of this symbol can be set to say ‘Prod’ or ‘Test’ before execution. Hence, the database reference is changed throughout the code that will execute. Similarly, dates, conditions, table prefixes, even clauses and whole statements can be parameterised.

QiD provides some built-in symbols such as {JobId} and {Date}. You can also define and give values to your own symbols.

[Image - Example of Symbol Substitution]