2020.2

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 maximum 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.
l
All: Select to include all records in the database in the sample data file.
l
Records: Select to define the range of records you want to include in the sample
data file.
Page 72