Defining SQL Tasks

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.