IQ Database
|
Specify the IQ destination database.
|
IQ Schema
|
Specify the IQ schema/owner
to restrict the objects shown and create new tables in that
schema.
|
IQ Pre Processing SQL
|
Create a script that runs during component initialization. Scripts can include one or more SQL statements. If you use
multiple statements, separate them with a semicolon (;).
|
IQ Post Processing SQL
|
Create a script that runs after all components
execute. Scripts can include one or more SQL statements. If you use
multiple statements, separate them with a semicolon (;).
|
Use Remote Definition
|
Select this option only if you have defined
the source server as your remote server on the destination IQ database
using the Create Server command. If you do not
select this option, you are directly connected to the source data
using the configuration information provided in the .INI or interfaces file.
|
Source Schema
|
Specify the schema/owner to
restrict the objects displayed.
|
Source Pre Processing SQL
|
Create a script that runs during component initialization. Scripts can include one or more SQL statements. If you use
multiple statements, separate them with a semicolon (;).
|
Source Post Processing SQL
|
Create a script that runs after all components
execute. Scripts can include one or more SQL statements. If you use
multiple statements, separate them with a semicolon (;).
|
Function
|
Select one of these load functions: Insert – to load records directly from
the source into the selected target table.
Upsert – to update the existing records
and insert the new records. When you select Upsert, the existing
records are replaced and not updated on an attribute level. The
table you are working with must have a predefined primary key.
If you have selected the Truncate option, all records are
removed from the target table before loading. The Insert and Upsert
function loads all records to the target table directly.
|
Create Target Tables
|
Create the destination tables if they
do not exist.
|
Continue on Error
|
Continue execution even if an error occurs
when loading data into the database.
|
Limit Rows
|
Specify the maximum number of rows to
insert into the table. The default is 0 for no limit.
|
Skip Rows
|
Specify the number of rows to skip at
the beginning of the input tables for a load. The default is 0.
|
Encrypted Password
|
Transmit the password in encrypted format.
|
Packet Size
|
Specify the network packet size.
|
Load Script
|
The Insert Location statements
are generated at runtime based on the component settings, if this property
is empty.
To use a customized script, right-click the component and
select Generate Load Script. The Insert
Location script is generated for Insert. After you generate
the script, you can click Load Script and edit the script.
Note: If you have provided a custom Load Script, the Function property
is ignored.
|
Use IQ Multiplex
|
Support multiplex execution by using
multiple writers to load data into the IQ database.
|
IQ
Lock Table in Exclusive Mode
|
Lock the target table to prevent it from
being updated by concurrent transactions. When an exclusive table lock
is applied, no other transaction can execute queries or perform
any updates against the locked table. The IQ Lock Table in Exclusive
Mode option also queues multiple projects that load the same table
in Sybase IQ.
|
Wait Time for IQ Lock Table
|
Specify the maximum blocking time that
the project should wait before acquiring an exclusive lock.
Specify the time argument in the format hh:mm:ss.sss.. When you do
not enter a time argument, the server does not wait.
When you specify “00:00:00.000” as the time argument, the server waits indefinitely until an
exclusive lock is available or an interruption occurs.
|
Transactional
|
All work performed by the component, including preprocessing SQL statements and postprocessing SQL statements, is done in
a single database transaction that is committed when the project
finishes normally. Select this option to roll back the transaction,
if this component encounters an error.
|