Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Introduction (Email) • Setup • Versago & Bizweaver Templates • Introduction (Bizweaver)
bizweaver:sql

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
bizweaver:sql [2024/09/24 15:33]
dlee [Basic Tool Setup] 		bizweaver:sql [2024/09/24 15:37] (current)
dlee [SQL Tips]
Line 18: Line 18:
 Four SQL Server command types are supported: Four SQL Server command types are supported:
  
-  * **//[[bw2:sql_command_tool#Reader (SQL Server and HANA)|Reader]]//** +  * **Reader (SQL Server and HANA)** 
-  * **//[[bw2:sql_command_tool#Non-Query (SQL Server only)|Non-Query]]//** +  * **Non-Query (SQL Server only)** 
-  * **//[[bw2:sql_command_tool#Post Execution Query (SQL Server only)|Post Execution Query]]//** +  * **Post Execution Query (SQL Server only)** 
-  * **//[[bw2:sql_command_tool#Stored Procedure (SQL Server only)|Stored Procedure]]//**  +  * **Stored Procedure (SQL Server only)**  
  
 Only the **Reader** function is supported for HANA databases at this time. Only the **Reader** function is supported for HANA databases at this time.
Line 65: Line 65:
  
  
-{{ :bw2:bizweaversqltool2.png |}} 
  
 =====Stored Procedure (SQL Server only) ===== =====Stored Procedure (SQL Server only) =====
Line 80: Line 79:
  
  
-====== User Notes ======+===== User Notes =====
  
   - Any “calculated” value in a SQL statement must have an alias assigned for it to be available in Bizweaver. This applies to numeric calculations, concatenated text values, CASE values, and any other instance where the value is not a column name in a table. Standard syntax rules apply for assigning alias names.   - Any “calculated” value in a SQL statement must have an alias assigned for it to be available in Bizweaver. This applies to numeric calculations, concatenated text values, CASE values, and any other instance where the value is not a column name in a table. Standard syntax rules apply for assigning alias names.
Line 88: Line 87:
  <code>'WorkFlow(GetData).Get({FIELD_ItemCode})'</code>  <code>'WorkFlow(GetData).Get({FIELD_ItemCode})'</code>
  
-====== SQL Test Run Option ======+===== SQL Test Run Option =====
 Bizweaver version 2.3 introduces the **Execute** option in the SQLCommand tool.  This option allows you to test SQL functions without running through the entire workflow.  It also allows you to test SQL steps where the input involves variables from previous steps.  The example here uses the following SQL statement. Bizweaver version 2.3 introduces the **Execute** option in the SQLCommand tool.  This option allows you to test SQL functions without running through the entire workflow.  It also allows you to test SQL steps where the input involves variables from previous steps.  The example here uses the following SQL statement.
  
Line 111: Line 110:
 </WRAP> </WRAP>
  
-====== SQL System Variables ======+===== SQL System Variables =====
  
 ^ Name           ^ Description         ^ ^ Name           ^ Description         ^
Line 124: Line 123:
  
  
-======SQL Tips======+=====SQL Tips=====
   * **[[bw2:sql tools|Strip HTML Tags From Input String]]**   * **[[bw2:sql tools|Strip HTML Tags From Input String]]**
  
bizweaver/sql.1727206410.txt.gz · Last modified: 2024/09/24 15:33 by dlee

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki