To define an import task:
|Choose Define, Tasks, Import Tasks.
|The Import Tasks window appears.
|In the Import Name field, type a unique name for the import task. The name can be up to 30 characters long.
|Click the Import SQL Statements tab page to enter information in each of the following fields.
|For each SQL statement that you want to have performed on the external data, application tables, or parameter sets:
•In the Sequence field, type a (sequence) number to indicate the order in which the SQL statements are to be executed. It is a good idea to start numbering from 10 upwards, in units of 10, so that you can insert other statements later, if required.
•In the Active field, check or clear the box to activate or deactivate statements that you may have used for debugging purposes.
•In the Disable Rules field, check or clear the box to specify whether rules (constraints, relationships, mandatory columns, allowed values, and more) need to be disabled or not when executing this Import SQL statement. This enables you to speed up performance when the data comes from a trusted source and is therefore expected not to contain any errors. Refer to "Disabling Rules" for more information.
•In the Description field, type a description of the purpose or nature of the SQL statement.
•In the SQL Statement field, enter the SQL statement. You can click the Edit button to open the popup text editor, or click the SQL Definer button to start the Graphical SQL Definer (for more information on the Graphical SQL Definer, see the USoft Definer Help).
|Click the Import Task Sets tab page to enter information in each of the following fields. For each external set that is used by this import task:
•In the Set Name field, click the lookup button and select a previously defined external set.
•In the Driving Set field, check or clear the box to indicate which of the external sets "drives" the import process. An import task must have exactly one driving set.
•In the Filename field, type the name of the file that contains the data to be imported. By default, USoft Batch looks for this file in the working directory, but you can override this by entering a full pathname before the file name.
•In the Use User Table field, check or clear the box to specify whether or not USoft Batch should use a user-defined database table for temporary storage of the external set.
•In the User Table field, specify the name of the table to use to store the external set temporarily.
|If the set to be imported has one or more import task set virtuals, specify the name, data type, and length.
NOTE 1: To view Log Information changes, click the Log Info tab. You can use the What's This? Help in the Log Info tab page for more information on each field.
NOTE 2: You can check the validity of the SQL statements by pressing the Check button. If the statements are correct, the Correct flag for the Import Task will be set to correct, that is, the checkbox will be checked. This is not a mandatory action, the state of the correct flag has no effect on the execution of the Import Task.