IQ Loader File via Load Table

The IQ Loader File via Load Table component loads data from a file into a target IQ database using an automatically generated LOAD TABLE statement.

This self-contained component operates as a datasource when it reads from source files and a data sink when it writes to a Sybase IQ database. It does not have input and output ports, therefore, there is no need to create one component for performing the read from the source file and another component for invoking Load Table in Sybase IQ. Sybase IQ InfoPrimer automatically generates Load Table statements that extract data from a delimited text file and loads the data to Sybase IQ.

• Configuring IQ Loader File Via Load Table Component
  Add and configure a IQ Loader File Via Load Table component to your project.
• Working with the Text Source Property Window
  The Text Source property window lets you define the structural properties of data in the source file.
• 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.
• IQ Loader File via Load Table Properties List
  Required and optional properties of the IQ Loader File via Load Table component.