User`s guide

CHAPTER 6 Components
User’s Guide 73
DB Option Default Description
Show error location 1 1 = yes 0 = no
Database errors will include the position of
the record within the result set, when Show
error location = 1
.
Always use logon
credentials
0 Always use logon credentials.
Extended
connection option
Extended connection option.
Connect timeout 0 Stops trying to connect after Connect
timeout seconds. If set to 0, the connect will
not time out
Disconnect timeout 10 Enforces disconnect from the database, if
there was no reply from database n seconds
after trying to disconnect.
Treat numeric
values as character
0 1 = Treats numeric values as characters.
Always Unicode 0 Unicode will be forced (DB2).
Isolation Level DEFAULT Database specific.
Lock result set data 0 Query tables will be locked. This is used to
ensure that no data is written to the selected
record set while the process in working on
it. The selected record set is released when
the last record from that set was fetched.
This can be useful when dealing with data
integrity concerns.
LOB truncate size 1024 LOB will be truncated when exceeding
LOB truncate size.
Numeric Support 1 Support numeric values.
Execution timeout 0 Component will stop execution after a time
interval in seconds (
0 = no timeout.)
Unicode support 0 Support Unicode operation.
Write rejected
records to file
File path for Reject Log.
This and the following options are used to
log records that have been rejected by the
database on loading
Note All other records of a data block will
be written to the database