This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
integration:rawdata:delimited:export [2011/03/14 14:21] 127.0.0.1 external edit |
integration:rawdata:delimited:export [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 3: | Line 3: | ||
{{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
- | ====== Adminstration: Raw Data Files ====== | + | ====== Integration: Raw Data Files ====== |
===== Delimited Files ===== | ===== Delimited Files ===== | ||
Line 25: | Line 25: | ||
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 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. The these [[integration:rawdata:delimited:options|options]] are the same as those used in the CREATE TABLE statement. | + | The Omnidex EXPORT statement has several options for generating different types of raw data files. These [[integration:rawdata:delimited:options|options]] are the same as those used in the CREATE TABLE statement. |
This simple example exports all of the columns and rows from a table. The options used will create a comma-delimited file appropriate for the Microsoft Windows operating system that honors quotation marks. | This simple example exports all of the columns and rows from a table. The options used will create a comma-delimited file appropriate for the Microsoft Windows operating system that honors quotation marks. |