SQL Tasks

Previous Next

A SQL Task is an operation defined by a SQL statement, or a sequence of SQL statements, that are executed in the context of a batch job.

You can use SQL Tasks to:

Have the Rules Engine add, change or drop data in your USoft application. For this, use INSERT, UPDATE or DELETE statements respectively.

Call components to execute a variety of tasks. For this, use the USoft INVOKE statement. It allows you to perform method calls in a SQL context.

collapseDefining a SQL Task
collapseActive, Disable Rules
collapseSQL Tasks for Export and Import
collapseSQL Tasks for subjobs