Variables customized by users. The variable name must only contain underscores, letters, and numbers. The variable value can be a fixed value or dynamically determined using SQL statements during task execution.

System-predefined variables. The variable name starts with the "@@" characters.

Enter the name of the variable here.

The variable name must only contain underscores, letters, and numbers.

In the same context, variable names cannot be duplicated. For example, within the same task, the name of a task variable must be unique, and within the same template, the variable names must also be unique.

Select the source for the variable value here.

The variable value can be a fixed value set during configuration, or it can be dynamically queried using an SQL statement during task execution.

If the "Variable Value Source" is "Fixed Value", you can enter a value for the variable here.

If the "Variable Value Source" is "Generated by SQL Query", then you need to enter the SQL query here to retrieve the value of the variable.

If this option is selected, when using this variable in an HTML document (such as the body of an email), the variable value will be inserted directly into the HTML document as HTML code.

For example, the value of a variable is "<a href='https://www.sqlmessenger.com'>link to web<a/>":

This option is not selected, the variable value will be displayed as plain text

This option is selected, the variable value will be displayed as a hyper link

If this option is selected, the system will allow the value for this variable to be passed in from the TASK_PARAMS field in an external interface table. For example, the following SQL statement will initiate a task with ID 123 and pass a value for the task's variable "UserName":

INSERT INTO sqlmessenger_intf INSERT INTO sqlmessenger_intf
            (oper_type,
             task_id,
             task_params)
VALUES      ( 'T',--Operation type. "T" indicates to start a task.
              123,--Task ID to start
              'UserName=Andy'
--Pass "Andy" as the variable value to the task's variable "UserName".
); 

Note: When passing variable values from the external interface table, the task will use the passed values as the variable values for this run, and the configured values for these variables will be ignored.

Select whether to allow this variable to have an empty value. If this option is not selected, the task will be aborted when the variable's value is an empty string.

When this option is selected, the system will perform a security check on the variable's value when it is used in an SQL statement. For example, if the value of variable "Month" is "202401;", the following statement will not be executed:

SELECT *
FROM   sales_stat
WHERE  sales_month = #month#; 

The value of the variable did not pass the SQL statement's security check

To avoid SQL statement execution failures caused by variable values containing special characters, you can modify the SQL query's parameter format to JDBC parameters, for example:

SELECT *
FROM   sales_stat
WHERE  sales_month = #[month]#; 

Using Variables in SQL Statements