2018.2

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
For a description of the options on the On Error tab see "Using the On Error tab" on page92.
Comments Tab
The Comments tab is common to all tasks. It contains a text area (Task comments) that lets
you write comments about the task. These comments are saved when the dialog is closed with
the OK button, and are displayed in the Task Comments Pane.
Check the option Use as step description to display the text next to the icon of the plugin in
the Process area.
Decompress File(s)
Decompress File action tasks decompress zipped job files (files compressed as zip files).
Input
This task only accepts ZIP files, however it is not necessary that the job file be the ZIP, since
this file path and name can be specified in the task itself.
Processing
Every file in the ZIP is extracted to the specified location. If a folder structure exists in the ZIP, it
is respected in the output folder.
Page 327