8.8

not doubled will be disregarded.
l Expect record set:Check if you are expecting a result from the database after
executing the SQLquery. If the query is expecting a record set in return and does
not return one, the task will trigger an error.
l Database connection string: Enter a variable connection string in this box. To do
this you may begin by clicking to create an ODBC connection string to the data
source and paste the string automatically to this box. Note that if a login name and
password are required to connect to the database, a dialog box is displayed and the
information you enter is saved in the configuration of the PReS Workflow Database
action task. Another option, if a database connection string (not a database path and
name) was already entered in the Database Connection tab, is ti simply copy and
paste it to this box. Bear in mind that if the Parse normally option is not selected, any
backslashes included in the connection string that is not doubled will be
disregarded. Once your connection string is displayed in this box, you can edit it by
adding variables or data selections.
l SQL statement: Enter your SQL statement. Remember that you may use variables
and data selections in your statement.
On Error Tab
The On Error tab is common to all tasks. Details can be found in the" Task Properties Dialog"
on page771.
By default, any action task, branch, splitter or condition that generates an error will simply be
ignored, and the task just under it (not within a branch)will be given control of the job file
without any modification. Any initial input task that generates an error will stop the process from
running as a whole, and output tasks will not generate output. The On Error tab can be used to
overwrite the default behaviors.
l Send to Process: Check this option to send the job file to an error management process.
l
Error Process drop-down:Enabled only when the Send to Process option is checked.
Lists any process of which the initial input task is the Input Error Bin task.
l Action:In the initial input tasks, this group is disabled and defaults to Stop Process. In
all other tasks where the On Error tab is present, the following options are available:
l Default:By default, the task is ignored as if it did not exist and the error is logged
before continuing the branch or process; the job file is passed on to the next task in
the process. When an error occurs in a loop (or in a plugin that acts like a loop), the
loop may log the error, terminate the current iteration and proceed with the next
Page 300