2022.2

Advanced SQL Statement dialog box. The alternate syntax may be required for some
database types.
l
Client-side Cursor: When this option is enabled, the complete result set is downloaded
before processing starts, and changing records is done by PReS. This is generally faster
for queries returning a small number of results ; otherwise the start of the record pro-
cessing can be delayed since the whole record set must be downloaded.
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
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
Test SQL button: Verify the SQL statement's validity.
Data Repository Manager
The Data Repository Manager is an interface that manages the PReS Workflow "Data Repository" on
page79. This feature, introduced in version 8.5, is a persistent data store used to save any sort of tex-
tual data in a table format.
Accessing the Data Repository Manager
To access the Data Repository Manager:
l
Open PReS Workflow
l
Go to the Tools tab.
l
Click the Data Repository Manager button in the Managers group.
Caution: Any change made within the Data Repository Manager is Immediate, and
Irreversible. Deleting data from this interface may impact running processes if such processes
access the data saved in the repository. This includes clearing a group, or clearing the repos-
itory.
Toolbar buttons
l
Group section
l
Add Group: Click to create a new group. Enter the group name and click OK.
Three keys will be added to the group automatically: ID, DateC and DateM . These keys
cannot be removed or edited.
Page 707