User`s guide

Overview
74 Sybase IQ ETL 4.1
9 Set the Read Block Size.
The Read Block Size option defines the number of records retrieved by the
component within in a single step.
Use a fairly small number during simulations to accelerate the simulation
step. Increase the number before you execute the project. Executing a
project with a small number might have a negative effect on the overall
performance of the system.
10 Set the Write Block Size.
The Write Block Size option defines the number of records to be written
to the database in a single write operation. A component with a large Write
Block Size will be waiting to receive as many records as defined before
the data records are actually written to the database. To enforce writing
after a simulation step, the number for Write Block Size should be equal
or smaller than the Read Block Size of the previous component with a
Read Block Size property.
11 Set up pre-processing SQL.
One or more SQL statements can be executed during the initialization of a
component. Initialization is the first step each components passes when
starting a simulation or when executing a project. When the project is
initialized, all components of the project are initialized subsequently.
Note When using multiple statements, you can separate the statements by
using a semicolon.
12 Set up post-processing SQL.
Truncate reject log 1 Log will be truncated on database connect.
A value of 0 will append data to an existing
log file.
Write error code to
reject log
1 The database error code for each record
will be written to the log.
Write error text to
reject log
1 The database error text for each record will
be written to the log.
Write header to
reject log
0 If set to 1, a column header will be written
to the log.
Reject log column
delimiter
Tab The columns will be delimited by this
character or string.
DB Option Default Description