transformations:sqlcommand
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:sqlcommand [2016/06/19 18:44] – created dmitry | transformations:sqlcommand [2021/06/22 10:37] – [Action settings] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== SQL Command | + | {{ transformations: |
+ | ====== | ||
+ | Category: Workflow / External\\ | ||
- | Sends a free-form SQL query to a database, | + | \\ |
+ | =====Description===== | ||
+ | This action performs one of these 4 commands on a specified | ||
+ | * Create database table | ||
+ | * Delete database table | ||
+ | * Delete all rows | ||
+ | * Custom command | ||
- | The query can include [[: | + | \\ |
+ | =====Use cases===== | ||
+ | * Export data into a database by instructing the database to bulk load a text file (e.g. previously generated by EasyMorph) | ||
+ | * Trigger stored procedures | ||
- | TRUNCATE TABLE " | + | \\ |
+ | =====Action settings===== | ||
+ | ^ Setting | ||
+ | |Connector< | ||
+ | |Command|Select the process to run on the database. | ||
+ | |Advanced (Timeout)|Set the number of seconds for this process to complete before timing out. Default is 1800. If the action has not completed within the set Timeout, the workflow stops and displays an error.| | ||
+ | < | ||
- | The query can include multiple statements, if this is supported by the database connector. | + | \\ |
+ | ====Create table settings==== | ||
+ | **Description: | ||
+ | Field types are automatically suggested based on the input dataset but can be changed manually. Field names are taken from the input dataset. They are case-sensitive. | ||
+ | ^Settings ^Description ^ | ||
+ | |Table name< | ||
+ | |If table already exists|Select how EasyMorph handles cases when the named table already exists in the target database.\\ | ||
+ | |Data types|Select whether to use //Simple// or // | ||
+ | |Field list|Select the columns to insert into the new table and the data type of each column. | ||
+ | < | ||
- | ** Use cases ** | + | \\ |
- | * Export data into a database | + | ====Delete table settings==== |
- | * Truncate/ | + | **Description: |
- | * Trigger stored procedures | + | ^Settings ^Description ^ |
+ | |Table name< | ||
+ | |If table doesn' | ||
+ | < | ||
+ | |||
+ | \\ | ||
+ | ====Delete all rows settings==== | ||
+ | **Description: | ||
+ | ^Settings ^Description ^ | ||
+ | |Table name< | ||
+ | |If table doesn' | ||
+ | <sup>*</sup> Setting can be specified using a [[: | ||
+ | |||
+ | \\ | ||
+ | ====Custom command settings==== | ||
+ | **Description: | ||
+ | ^Settings ^Description ^ | ||
+ | |Statement|Enter the free-form SQL query to send to the database. | ||
+ | Example: | ||
- | ** See also ** | + | \\ |
- | * [[http:// | + | =====See also===== |
+ | | ||
+ | | ||
+ | * [[transformations: | ||
+ | * [[: | ||
+ | * [[http:// |
transformations/sqlcommand.txt · Last modified: 2022/12/05 14:23 by craigt