2022.2

Output
The result of the query is output in the selected data format. The current emulation is changed to the
selected format. Metadata and Job Info variables are not modified in any way.
Job Information definitions
l
%1 - DB Connection String
l
%2 - The actual query used
l
%3 - The number of records returned.
Task 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 pass-
word 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 to 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 inten-
ded 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.
Page 369