8.5

Properties
Database Connection tab
l Database group
l Location: Enter either the path and name of the database or a database connection string in this
box. You may click to navigate to the database and paste the database path and name
automatically to this box. You may also click create an ODBC connection string to the data
source and paste the string automatically to this box. If a login name and password are required
to connect to the database, a dialog box is displayed and the information you enter is saved in
the configuration of the PReS Workflow Database action task.
l Table/Query: Select the table or query containing the information you need as your input data.
l Range group
l All: Select this option use all the records included in the database.
l Records: Select this option use only some of the records in the database. Indicate the range by
entering the number of the first record followed by a dash and the number of the last record. To
use records 50 to 75, for example, enter 50-75. Note that this option is intended mostly for testing
purposes, since in real life scenarios, you typically want to use all the records stored in a
database.
l
Emulation group:Use options from this group to customize the data file generated by the PReS
Workflow Database action task.
l Output file emulation: Select the emulation corresponding to the type of output file you want the
PReS Workflow Database action task to generate.
l CR-LF replacement: If you want CR-LF (Carriage Return-Line Feed) characters within the data
file to be replaced by another character, use this box to indicate which character to use. You may
select the replacement character from the list or type your own.
l Emulation options group:Options from this group change based on the selected output file
emulation.
l PReS Workflow Database Emulation:If you selected PReS Workflow Database in the Output
file emulation box, the following options are available:
l Create data pages as follows: Select the option that will be 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 listed in this box.