Adding a Destination Table
You can write the transformation results or inbound data to an existing table or add a destination table based on existing ports in the project. You cannot add a table based on a port structure from the Database Configuration window or Properties window. You must select the port structure in the Design window.
Enabling Client-Side Load Support
You can load data into the Sybase IQ table, from files that are located on a different host machine than Sybase IQ. You need not install Sybase IQ InfoPrimer Development and Sybase IQ on the same machine; Sybase IQ InfoPrimer Server and Sybase IQ can communicate in a networked environment, allowing you to bulk-load from a remote machine in a single step.
Multiple Writers Configuration for Loading Data
Sybase IQ InfoPrimer supports the multiple writer functionality that is available in Sybase IQ 15.0; you can add multiple writers for loading data into an IQ database. Multiple writers allow parallel loading of Sybase IQ tables, which is faster than sequential loading.
DB Bulk Load Sybase IQ Properties List
DB Bulk Load Sybase IQ properties list identifies the connection parameters and other items you define on the Database Configuration window.
DB Bulk Load Sybase IQ and DB Space
If you are using the Bulk Load Sybase IQ component and the project or job takes a long time to execute, and if you see an out of space message in the Sybase IQ console or log, you need to add another dbspace.
Customizing the IQ Loader Data Format
The IQ Loader Interface uses default values for delimiters, null handling, and character sets when writing to the data file or pipe, and when generating the LOAD TABLE script.