This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
integration:rawdata:delimited:export [2011/03/14 14:21] 127.0.0.1 external edit |
integration:rawdata:delimited:export [2012/10/26 15:34] 127.0.0.1 external edit |
||
---|---|---|---|
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. |