Differences

This shows you the differences between two versions of the page.

--- bw:sql_command_tool [2022/06/07 09:49]
akoehler [Reader (SQL Server and HANA)] added Wrap for SQL/HANA Reader
+++ bw:sql_command_tool [2022/08/02 10:35] (current)
akoehler [SQL System Variables]
@@ Line 136: / Line 136: @@
 Click the green <color #22b14c>Run</color> link to execute tests.  If you click the "Test Run" link again the results will revert to the statement in the [SQL] tab.
 </WRAP>
+====== SQL System Variables ======
+^ Name           ^ Description         ^
+| CommandType       | The command type chosen in the SQL tool ex. Reader, Non-Query      |
+| DataSourceFields |The fields pulled from the data source will only show up when executing the query in the SQL tool and not during a test run|
+| DataSourceResultsTable         | The results from executing the query in the workflow. Will only show up when executing the query in the SQL tool and not during the test run      |
+| QueryString         | The current query that is being executed     |
+| SQLCommand        | Used for an older version of Bizweaver no longer returns a value    |
+| SQLResultsCount         | The total amount of records that were retrieved during a query       |
+|StepMessage       | During a failure the reason for failure will be populated here     |
+| StepStatus        | True or False     |
 ======SQL Tips======

Wiki