Methods for Exporting Data from a Database

To export IQ data from your database in this version of Sybase IQ, Sybase recommends that you use the methods documented in this guide.

You may also export data by using a front end tool, written by you or a third party, that effectively queries the IQ database and formats the data as desired.

To export tables (other than your system tables) from your catalog store, use the methods in this guide.

• Output Redirection
  Output redirection can be used to export query results.
• Data Extraction Facility
  The data extraction facility is a group of database options that improve performance dramatically for queries with large result sets.