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/21 02:46] – 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 run before timing out. Default is 1800.| | ||
+ | < | ||
- | 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