DB Read
Runs a query on a database and saves it into the database.
| Parameter | Description |
|---|---|
| AddDatatables | If StorageActionNet is set to no storage and Add Datatables is set to true the table can be used as a variable. |
| AddShiftAndRun | Adds a shift and run number column to the data table before storing it into the database. |
| ClearTable | Wipes the content of the database table before writing in collected data. |
| ConnectionString | Connection String to database that data will be read from. |
| Filter | Filters data returned when StorageActionNet is set to Overwrite with a sql statement. Example: SiteCode = 'HOU' or Length = 16. |
| GetSchema | Grabs the schema of the incoming data used to build better tables. Has problem with some queries. |
| InsertColDupeTest | Updates instead of inserting a new row based on a key should be used with Storage Action Append Update. |
| MapByColIndex | If true will use column indexes to map data else it will use column names to map data handy if you want to add extra columns to the table. |
| OverrideConnectionWrite | Output data to a different MS SQL database. |
| Provider | Type of database connection to be used oleDB, ODBC, SQL. |
| SQLQuery | SQL Query to be run on the database that will return a table. |
| StorageActionNet | How DB Write should handle the data table. |
| Table | Table DGS is to write data too. |