Executing SQL Statements and Creating Transitions Based on the Results
SQL statement execution workflow steps are used when a workflow must be routed based on the result of a query. An SQL statement execution workflow step runs a SQL query and returns its results as the result of that workflow step.
The following rules apply to creating an SQL statement:
-
Use only SELECT statements.
-
You can use tokens within the WHERE clause.
-
A query must return only one value.
Create a new execution step source with the field values as defined in Table 7-5. Execution window values for executing SQL statements.