2020.1

1. Open the Data Selector (see "The Data Selector" on page835).
2.
From the Emulation drop-down list, select Database.
3.
Next to the Sample data file field, click the Configure Database button.
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 database, 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
Page 71