IQ Loader DB via Insert Location properties list

IQ Loader DB via Insert Location properties list identifies the connection parameters and other items you must define on the IQ Loader DB via Insert Location component window.


Required properties

Property

Description

IQ Host Name

Specify the host where the Sybase IQ target is running.

IQ User

Specify an authorized IQ user to protect the database against unauthorized access.

IQ Password

Specify a password to protect the database against unauthorized access.

Source Host Name

Specify the data source.

Source Database

Specify the source database.

Source Transfer List

Specify the schema qualified source table name and the target table name. In the target truncate column, specify 1 to truncate the target table, otherwise enter 0.


Optional properties

Property

Description

IQ Database

Specify the IQ destination database

IQ Schema

Specify the IQ schema/owner to restrict the objects displayed 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.

NoteIf a custom Load Script is provided, 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:nn:ss.sss. If you do not enter a time argument, the server waits indefinitely until an Exclusive lock is available or an interruption occurs. When you specify “00:00:00.000” as the time argument, an Exclusive lock is acquired as soon as the project starts.

Transactional

All work performed by the IQ Loader DB via Insert Location component, including pre-SQL and post-SQL, 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. See “Job components” and “Enabling transactionality for projects and jobs” for information on the “Propagate Rollback” property.