Differences

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

--- transformations:sqlcommand [2021/06/21 02:46] – craigt
+++ transformations:sqlcommand [2022/12/05 14:23] (current) – craigt
@@ Line 6: / Line 6: @@
 =====Description=====
 This action performs one of these 4 commands on a specified database:
+  * Custom command
   * Create database table
   * Delete database table
   * Delete all rows
-  * Custom command
+  * List tables
+  * List table fields
 \\
@@ Line 21: / Line 23: @@
 |Connector<sup>*</sup>|Select or create a connector to the database.|
 |Command|Select the process to run on the database.  Options:  //Create table//, //Delete table//, //Delete all rows//, or //Custom command//.|
-|Advanced (Timeout)|Set the number of seconds for this process to run before timing out.  Default is 1800.|
+|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.|
 <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
+\\
+====Custom command settings====
+**Description:**  Sends a free-form SQL query to the specified database.
+^Settings ^Description ^
+|Statement|Enter the free-form SQL query to send to the database.  The query can include [[:parameters]] wrapped in braces, which will be replaced with their values during runtime.|
+Example:  ''  LOAD DATA INFILE '{FileName}' INTO TABLE {TableName};  ''
 \\
@@ Line 52: / Line 61: @@
 \\
-====Custom command settings====
+====List tables settings====
-**Description:**  Sends a free-form SQL query to the specified database.
+**Description:**  This command creates a two-column dataset consisting of the Schema name and Table name of all tables in the target database.  No settings are required.
+\\
+====List table fields settings====
+**Description:**  This command creates a three-column dataset consisting of the Column name, Column data type, and any Column annotations of all fields in the target table.
 ^Settings ^Description ^
-|Statement|Enter the free-form SQL query to send to the database.  The query can include [[:parameters]] wrapped in braces, which will be replaced with their values during runtime.|
+|Table name<sup>*</sup>|Select the database table to retrieve details from.|
-Example:  ''  LOAD DATA INFILE '{FileName}' INTO TABLE {TableName};  ''
+<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
 \\