Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Layout Basics • Control Properties • SQL/HANA Tool • SMTP OAuth setup with Microsoft Exchange Online • Using APP Report Maintenance and Delivery • Scheduled Run • Supported Browser Platforms • Salesforce.com API • Versago & Bizweaver Templates • Introduction (WebService Tool)
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 11: Line 11:
       * The SQL Command tool uses a previously defined SQL/HANA connection to connect to the desired database.       * The SQL Command tool uses a previously defined SQL/HANA connection to connect to the desired database.
   - **Command Type** selected from the drop-down list.   - **Command Type** selected from the drop-down list.
-    -* See the //Command Types// section below for more information.+      * See the //Command Types// section below for more information.
   - **SQL Command** Enter a SQL statement in this area.   - **SQL Command** Enter a SQL statement in this area.
  
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.1727206391.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