2022.2

4. Associate a database.
l
Microsoft Access Database or dBase file: In Database, enter the path of the Microsoft
Access database or dBase file, or click the Browse button to the right of the box to navigate
to, the database file. Recall that a Microsoft Access database file bears the extension
.mdb, and a dBase file bears the extension .dbf. If the file is a dBase file, you must specify
the folder that contains the .dbf file. The folder in this case is considered to be the data-
base, while each individual .dbf file is a table in the database. Once you enter the path, the
Table/query name box updates to reflect the tables and queries available in the selected
database.
l
ODBC Data Source: In ODBC Data Source, click to connect to an ODBC Data Source.
Use the Select Data Source dialog box that appears to select an existing Data Source or
set up a new one. When you exit the Select Data Source dialog box, the Database box
updates to display the connection string it uses to connect to the database, and the
Table/query name box updates to reflect the tables and queries available in the selected
database.
Note: Since the Workflow tool is a 32-bit application, it can only use 32-bit ODBC
data sources. Make sure you use the proper Windows application (ODBC Data
Sources (32-bit)) to create and manage data sources that can be used in Workflow.
5. Click Edit SQL to create the SQL query by hand to define the SQL query that retrieves the data
your document requires.
6. Set the properties that define a record set:
l
Condition: Select the condition that signals the end of a record set. Three possibilities
exist: create a new record set for each record, create a new record set after every x
records, or create a new record set when the value of a specific field changes.
l
Sort on condition field: Select this if the condition you set is to create a new record set
when the value of a specific field changes, and you want to sort the records before applying
that condition.
l
Maximum records per record set: Set either the number of records in each record set, or
the maximum number of records in a record set. An individual record set can contain a max-
imum of 4000 records.
7. Set the number of records you want to include in the sample data file. The number of records you
set should provide a reliable sample to ensure your document executes properly with any of the
data it may encounter at runtime.
Page 65