How to set an Instance Variable using SQL

The following SQL is an example of how to set and instance variable :

update config_var
set Var_Value = '2010'
where var_name = 'Year'


In this example, the variable $Year is set to "2010".

Instance variables can be called accross feed, and are ideal for storing a piece of data that is passed from one feed to another.

It is appropriate to execute this SQL in a container step or in the external process tab of any feed.