Defining SQL Tasks

Previous Next

See Also

A SQL task executes one or more SQL task statements. Unlike import and export tasks, you do not use SQL tasks to convert data to and from USoft applications, but to manipulate data in the application's database.

For example, you can use SQL tasks to:

· Consolidate at night the data that has been entered during office hours.


· Delete old information.


· Check and update the data in the database when table definitions or constraints have been altered to suit newly formulated needs.

You can include SQL task statements for debugging purposes, and then deactivate them later, when your testing is finished.

Related Topics:

SQL Task Example

SQL Task Definition Steps

How to Define a SQL Task and its Statements