2022.2

l
XML for PrintShop Mail: This emulation is specifically for use with merging your data with
a PrintShop Mail document, using the PrintShop Mail task (see PrintShop Mail). No
options are offered, as this format is static and should not be modified.
l
Alternate syntax: Select to prevent automatically enclosing the names of any database tables
and fields that appear in the SQL query in square brackets when it exits the Advanced SQL
Statement dialog box. The alternate syntax may be required for some database types.
l
Edit SQL: Click to create and test an advanced SQL query; see "Advanced SQL Statement Dia-
log" on page709.
l
Import Config: If you previously created and exported a PlanetPress Workflow Database Con-
nection configuration, click this button to import it. This saves you the trouble of configuring the
connection every time.
l
Client-side Cursor: When this option is enabled, the complete result set is downloaded before
processing starts, and changing records is done by PlanetPress Workflow. 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
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 PlanetPress 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
Page 373