Differences

This shows you the differences between two versions of the page.

Link to this comparison view

integration:rawdata:fixed:export [2016/06/28 22:38] (current)
Line 1: Line 1:
 +~~NOTOC~~
  
 +{{page>:top_add&nofooter&noeditbtn}}
 +
 +====== Integration: Raw Data Files ======
 +
 +===== Fixed-length Files =====
 +
 +[[integration:rawdata:fixed:home|Overview]] |
 +[[integration:rawdata:fixed:environments|Environments]] |
 +[[integration:rawdata:fixed:datatypes|Datatypes]] |
 +**[[integration:rawdata:fixed:export|Exporting]]** |
 +[[integration:rawdata:fixed:limitations|Limitations]] |
 +[[integration:rawdata:fixed:example|Example]]
 +
 +----
 +
 +==== Exporting Data to Fixed-length Files ====
 +
 +The Omnidex EXPORT statement can be used to create fixed-length data files from another Omnidex environment.  For example, users can connect to an Omnidex Environment File that accesses a relational database and then export fixed-length data files for use in a data mart.  In fact, this approach is the basis for [[admin:features:snapshots:home|Omnidex Snapshots]]. 
 +
 +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.  By default, the EXPORT statement will create a fixed-length data file, and so no options are needed to produce these files. 
 +
 +This simple example exports all of the columns and rows from a table.  No options are needed for fixed-length data files.
 +
 +<code>
 +export        (select        *
 +                 from        INDIVIDUALS)
 +  to          individuals.dat
 +  with        DELETE;
 +</code>
 +
 +=====  =====
 +
 +**[[integration:rawdata:fixed:datatypes|Prev]]** |
 +**[[integration:rawdata:fixed:limitations|Next]]**
 +
 +====== Additional Resources ======
 +
 +See also: 
 +
 +{{page>:integration:rawdata:see_also&nofooter&noeditbtn}}
 +
 +{{page>:bottom_add&nofooter&noeditbtn}}
 
Back to top
integration/rawdata/fixed/export.txt ยท 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