2022.2

Note: MySQL, using ODBC 5.0, must be set to use a client-side cursor.
Microsoft Access will always work better when using a Server-Side cursor.
l
Include password in config: Select to save an encrypted version of the database password (if
any) within the exported configuration.
l
Export Config: Click to export the currently displayed properties of the task. The exported con-
figuration can then be reused on other PReS Workflow workstations.
Dynamic SQL Tab
l
Use dynamic values at run-time: Select to use a dynamic database connection string and / or
SQL statement at run-time. Check this box to enable the options included in this group (this dis-
ables the corresponding options in the General tab).
l
Parse normally: Select to interpret any backslashes included in the database connection
string as backslashes. If this option is not selected, any backslash that is 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 data-
base connection string (not a database path and name) was already entered in the Data-
base Connection tab, is to 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 are 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.
Miscellaneous Tab
The Miscellaneous tab is common to all tasks.
Check the option Use as step description to display the text next to the icon of the plugin in the Pro-
cess area.
Page 372