This is an old revision of the document!


Integration: Raw Data Files

Omnidex Standalone Tables

Exporting Data to Omnidex Standalone Tables

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;

Additional Resources

See also:

 
Back to top
integration/rawdata/ost/export.1436895253.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0