📄️ SQL tasks
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.
📄️ Action tasks
An action task is an operation defined by a call to one of the function offered by USoft's proprietary action language a SQL statement, for example, MessageInformation(), CommandWindows(), or ActionDecision().
📄️ Export tasks
Export tasks are useful if:
📄️ Export tasks: Creating external file layout
Often you want to create external files in a certain format so that they can be easily read or further processed by an external tool.
📄️ Import tasks
Import tasks are useful if:
📄️ Import task status files
During an import task, each file import can lead to import task status files being produced.
📄️ Import tasks: rejecting tables
Instead of having jobs produce import status files, you can use the database for import error handling. Several strategies exist:
📄️ Import tasks: Recognising external file layout
By default, USoft Batch allows you to specify how import records should be read. The external set used for the import task describes how external records are interpreted. This determines how USoft Batch recognizes fields within an import record.
📄️ Import tasks: Working with parameters
This article has tips for working with parameters in Import Tasks.
📄️ Job tasks
Job tasks are becoming obsolete. They are replaced by SQL tasks calling the Batchrunner component.
📄️ Messages in SQL tasks and Import tasks
Within SQL tasks and import tasks, you can call the MessageLanguage method of the internal RulesEngine component from an INVOKE statement.
📄️ Delayed processing of tasks
When new data are inserted or updated either through online data entry or an import task, you can delay business rules processing such as complicated calculations until a later moment.
📄️ Making tasks faster
Making SQL tasks faster
📄️ Deactivating and Reactivating Checks and Constraints
In some circumstances, you may want to deactivate certain checks or constraints. For example, when you define a job which is to import data , where you know that all the data to be imported is accurate and valid, you might turn off some constraints that check the data. In this way, you can improve the performance of the import task.