Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • SQL/HANA Tool • Designer Help • Versago & Bizweaver Templates • contact • Session Timeout • Salesforce.com API • Supported Browser Platforms • Introduction to Error Handling • Scheduled Run • 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:03]
dlee [Basic Tool Setup] 		bizweaver:sql [2024/09/24 15:37] (current)
dlee [SQL Tips]
Line 9: Line 9:
  
   - **Connection** Sets a connection to a database is selected from the drop-down list.   - **Connection** Sets a connection to a database is selected from the drop-down list.
-      - 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.
  
-====== Command Types ====== +===== Command Types =====
- +
-===== SQL Server =====+
  
 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)**  
- +
-===== HANA =====+
  
 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 69: Line 65:
  
  
-{{ :bw2:bizweaversqltool2.png |}} 
  
 =====Stored Procedure (SQL Server only) ===== =====Stored Procedure (SQL Server only) =====
Line 84: 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 92: 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 115: Line 110:
 </WRAP> </WRAP>
  
-====== SQL System Variables ======+===== SQL System Variables =====
  
 ^ Name           ^ Description         ^ ^ Name           ^ Description         ^
Line 128: 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.1727204633.txt.gz · Last modified: 2024/09/24 15:03 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