Data Extraction Facility

The data extraction facility is a group of database options that improve performance dramatically for queries with large result sets.

Like other database options, the data extraction options can be set either as temporary or permanent. Ordinarily these options are set as temporary. The extract options are set for a connection.

There are two advantages of using the extract options:

A binary format is supported, which allows loading the output data into the same or a different IQ database.
A SELECT statement with heavy output will run up to 4 times faster for ASCII output and up to 9 times faster for binary output.

The Extract Options
The extract options let you redirect the output of a SELECT statement from the standard interface to go directly to one or more disk files or named pipes.
Enabling Data Extraction Options
Use the data extraction options with care.

Parent topic: Methods for Exporting Data from a Database