Creating SQL Option Variable

Use these instructions to create SQL Option Variable.

  1. Select Administration > Variables from the menu bar. The Variable window is displayed.
  2. Select the SQL Option Variable folder.
  3. Click New. The Variable form is displayed.
  4. Specify this information for the SQL Option Variable definition.
    Name

    Specify a name for the variable.

    Note: Avoid using spaces in the variable name.
    Value

    Specify the value for the variable.

    Data Type
    Select the appropriate data type.
    Note: Value must be compatible with the selected data type.
    Function
    Specify a SQL function. Optionally, you can select a design variable if required.
    Note: To add single quote, select the Apply single quote for function check box.
    Description

    Specify a short description for the variable.

  5. Click Save & Close. The variable you created is now in the list box.l