2022.2

and indicates their widths. To change the indicated widths, simply click the values
displayed in the Width column and enter new values. Click OK when you are done to
close the dialog box. You will then no longer be able to use the Default width box.
l
XML Emulation: If you selected XML in the Output file emulation box, the following options
are available:
l
Create data pages as follows: Select the option used to generate the data pages.
Each data page created using the table or query selected above (Table/Query box)
can contain a single record, a fixed number of records, or a variable number of
records. To choose the last option, select one of the When [field name] changes lis-
ted in this box.
l
Sort on conditional field: Select this option if you want the table to be sorted using
the field selected in the Create data pages as follows box before the data page cre-
ation process is started.
l
Data encoding: Select the encoding used in the generated XML file. By default, this
option is set to the default encoding of the computer used to create or edit the con-
figuration. You may choose any encoding listed in the drop-down list or enter your
own.
l
Maximum records per page: Select this option if you want to limit the number of
records per page. This option is only available if you indicated that you wanted each
data page to contain several records in the Create data pages as follows box.
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706.
l
Import Config: If you previously created and exported a PReS Workflow Database Connection
configuration, click this button to import it. This saves you the trouble of configuring the con-
nection 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 PReS Workflow. This is generally faster for
queries returning a small number of results ; otherwise the start of the record processing can be
delayed since the whole record set must be downloaded.
Page 371