This shows you the differences between two versions of the page.
integration:rawdata:ost:export [2011/03/14 14:21] 127.0.0.1 external edit |
integration:rawdata:ost:export [2016/06/28 22:38] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ~~NOTOC~~ | ||
- | {{page>:top_add&nofooter&noeditbtn}} | ||
- | |||
- | ====== Adminstration: Raw Data Files ====== | ||
- | |||
- | ===== Omnidex Standalone Tables ===== | ||
- | |||
- | [[integration:rawdata:ost:home|Overview]] | | ||
- | [[integration:rawdata:ost:environments|Environments]] | | ||
- | [[integration:rawdata:ost:options|Options]] | | ||
- | [[integration:rawdata:ost:datatypes|Datatypes]] | | ||
- | [[integration:rawdata:ost:ofx|Offset Indexes]] | | ||
- | **[[integration:rawdata:ost:export|Exporting]]** | | ||
- | [[integration:rawdata:ost:limitations|Limitations]] | | ||
- | [[integration:rawdata:ost:example|Example]] | ||
- | |||
- | |||
- | ---- | ||
- | |||
- | ==== 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 [[integration:rawdata:ost:options|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. | ||
- | |||
- | <code> | ||
- | export (select * | ||
- | from INDIVIDUALS) | ||
- | to individuals.ost | ||
- | with OST INDEXBY='INDIVIDUAL;HOUSEHOLD' NULL_INDICATORS=OFF DELETE; | ||
- | </code> | ||
- | |||
- | ===== ===== | ||
- | |||
- | **[[integration:rawdata:ost:ofx|Prev]]** | | ||
- | **[[integration:rawdata:ost:limitations|Next]]** | ||
- | |||
- | ====== Additional Resources ====== | ||
- | |||
- | See also: | ||
- | |||
- | {{page>:integration:rawdata:see_also&nofooter&noeditbtn}} | ||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} |