Truncate Tables

Description

The Truncate tables action truncates one or several tables.

Options

Option	Description
Action name	The name of the workflow action.
Connection	Name of the database connection on which the tables reside.
Previous results to args	Check this option if you want to get in a dynamic way tables to truncate from results of previous workflow action.
Click here to return tables name list	This button will return all tables defined on the connection. Select tables (one or several) and press "OK". Tables name will be automatically added to "Selected tables" grid.
Selected tables grid	Specify here the tables to truncate (insert it manually or use the previous button). If the table is in a different schema than the default one, please specify the schema name.

Option

Description

Action name

The name of the workflow action.

Connection

Name of the database connection on which the tables reside.

Previous results to args

Check this option if you want to get in a dynamic way tables to truncate from results of previous workflow action.

Click here to return tables name list

This button will return all tables defined on the connection. Select tables (one or several) and press "OK". Tables name will be automatically added to "Selected tables" grid.

Selected tables grid

Specify here the tables to truncate (insert it manually or use the previous button). If the table is in a different schema than the default one, please specify the schema name.

Result

What this action passes on to the next action. See Action results for how results travel through a workflow.

Result	Value
True	Every table was truncated, with 0 errors. Also true when there is nothing to truncate: an empty list, or Previous results to args checked while there are no previous result rows (the tables in the grid are not truncated then).
False	At least one error occurred. A table that doesn’t exist, or a connection that is unknown or can’t be opened, counts as an error and stops the action: the tables after it are not truncated. An empty table name (in the selected tables grid or in a previous result row) also counts as an error, but later tables are still truncated.
Result files	Passed on unchanged.
Result rows	Passed on unchanged.
Lines deleted	The number of tables truncated, not the number of rows.

Result

Value

True

Every table was truncated, with 0 errors. Also true when there is nothing to truncate: an empty list, or Previous results to args checked while there are no previous result rows (the tables in the grid are not truncated then).

False

At least one error occurred. A table that doesn’t exist, or a connection that is unknown or can’t be opened, counts as an error and stops the action: the tables after it are not truncated. An empty table name (in the selected tables grid or in a previous result row) also counts as an error, but later tables are still truncated.

Result files

Passed on unchanged.

Result rows

Passed on unchanged.

Lines deleted

The number of tables truncated, not the number of rows.

With Previous results to args, the first field of each result row is the table name and the second field the schema name. A row with an empty table name is logged as an error and counts as one: later rows are still processed.