Page Comparison

Create a SQL task called SQL with Variable with the following SQL command:
 

<pre>
CREATE TABLE ${tutorial}${_date("yyyyMMdd",5) } (name varchar(128), value varchar(128));
</pre>

Click the Save button and then re-open the task.

Click the Variables tab and create a Variable with the following values:

• Name = tutorial
• *Value+ = task

Click the Save button and in the task Details, click the Update button.

Create a Workflow called Variable Workflow.

Add the SQL With Variable task to the Workflow and save it.

Launch Variable Workflow. and open the SQL With Variable task instance on the Activity Monitor. Note that the SQL command resembles the following, with the value from the task variable.
 

<pre>
CREATE TABLE task20090913 (name varchar(128), value varchar(128));
</pre>

Open the task and delete the task variable.

Go back to Variable Workflow and add the following variable:
 

<pre>
tutorial/workflow
</pre>

Open the task instance. The SQL command used the variable from the workflow because the task no longer had a variable.
 

<pre>
CREATE TABLE workflow20090913 (name varchar(128), value varchar(128));
</pre>