Configuring a DB Bulk Load Sybase IQ Component

Add and configure a DB Bulk Load Sybase IQ component to your project.

Drag a DB Bulk Load Sybase IQ component onto the Design window.
Connect the input port of the DB Bulk Load Sybase IQ component to the output port of the component that provides the inbound data.
In the Database Configuration window, add the Sybase IQ connection parameters.
Click the Destination icon and select the table where you want to load the inbound data. To write to a new destination table, see Adding new Sybase IQ destination tables.
Click the Load Stage icon. You can either:
- Select or enter the file name you want to use as a temporary data file and click Save, or,
- Add a pipe name in the Load Stage field (syntax: pipe://).
Click Finish.

To add DB Bulk Load IQ to your project:

Sybase IQ must be up and running before you add the component to your project. You can increase performance if you run both Sybase IQ INfoPrimer Server and the IQ database on the same machine; however, this is not required.
To connect to the target database on IQ, select a valid host name and interface.
To load the data into a new IQ table, you can create a destination table based on DB Bulk Load’s IN-port or the structure of any available port in the project.
To customize the script, right-click the DB Bulk Load IQ component, and select Generate Load Script. Click the Load Script icon in the Properties window, edit, and save your script.