Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example

The Omnidex EXPORT statement can be used to create Omnidex Standalone Tables from another Omnidex environment. For example, users can connect to an Omnidex Environment File that accesses a relational database and then export Omnidex Standalone Tables for use in a data mart.

The Omnidex EXPORT statement can export the results of any SQL statement, including statements that retrieve a subset of columns or rows, join tables, perform aggregations, or order the results. These SQL statements can also include SQL functions and expressions, allowing administrators to generate a wide variety of data files for their applications.

The Omnidex EXPORT statement has several options for generating different types of raw data files.

This simple example exports all of the columns and rows from a table to an Omnidex Standalone Table.

export        (select        *
                 from        INDIVIDUALS)
  to          individuals.ost
  with        OST INDEXBY='INDIVIDUAL;HOUSEHOLD' NULL_INDICATORS=OFF DELETE;

Prev | Next

See also: