SQL Data Check Legacy Action

About

The SQL Check Action object can be used to check data queries in the database, to ensure that data integrity and ensure that results are returned as expected.

Workflow tab

1. The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
2. It is usually used for debugging and not recommended for production environment.
3. It can be globally disabled using options dialogue

After execution tab

Specifies which variables will be set once action execution is completed

Example

SQL Data Check uses SQL scripts to check data in the database.

For example, the user may write the following SQL:

Select count(*) from table

• Execution is successful if the value of the first field of lookup query is more than 0
• Execution fails if the value of the first field of lookup query is equals to 0 or less than 0 or field type is not numeric.