The SQL math variable is used to retrieve data results using a SELECT statement. SQL is used to retrieve a value from the database using a query statement. The SQL statement should be constructed to return one value.
SQL Math Variable in Palette
Note: For a comprehensive explanation of the characteristics of this math variable, refer to the XML Configuration Guide in the Help menu.
Drag and drop the SQL Math variable from the Palette window onto the Math Pane. Enter the following information for the math variable.
Type a name in the Name field. This is required.
The applicable Data Types are: Boolean, Date, Decimal, Integer and Text. This is required.
Make sure variable type is defined as SQL. This is required.
Select Yes or No from Log field. Default is No. This is an optional field.
The Default is left blank and is an optional field. Required for Date and Integer data types so the system does not return a null value. For example, an integer default could be set to -999999999. Numeric and Date data types must consider a default whereas, text data type is more flexible and will not require a default value.
Enter the SQLQuery / SQL query statement. This is required.
Check-in the transaction to save the information to the database.