https://www.omnidex.com/docs/v54/ 2026-06-17T02:43:44+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:delimited:datatypes&rev=1467153531&do=diff Integration: Raw Data Files Delimited Files Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Datatypes The record layout described in the CREATE TABLE statement must exactly match the order of columns in the data file. Care must also be taken with binary columns to insure that the character content in the data file can be legitimately converted to the binary datatype declared in the table. If these record layouts do not match, O… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:delimited:environments&rev=1467153531&do=diff Integration: Raw Data Files Delimited Files Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Environments The Omnidex Environment File is the key to setting up Omnidex on raw data files. Delimited files do not contain metadata about columns and datatypes. The Omnidex Environment File fulfills this role. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:delimited:example&rev=1467153531&do=diff Integration: Raw Data Files Delimited Files Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Example The following example is a simple database using delimited files. Each table uses a different combination of column and record delimiters. The Omnidex Environment File is displayed below; however, the entire example, including sample data files, can be downloaded as a ZIP file at the following link: text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:delimited:export&rev=1467153531&do=diff Integration: Raw Data Files Delimited Files Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Exporting Data to Delimited Files The Omnidex EXPORT statement can be used to create delimited files from another Omnidex environment. For example, users can connect to an Omnidex Environment File that accesses a relational database and then export delimited files for use in a data mart. In fact, this approach is the basis for Omnidex Snap… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:delimited:home&rev=1467153531&do=diff Integration: Raw Data Files Delimited Files Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Overview Delimited files separate the content of columns and rows using special delimiter characters. These are commonly used by relational databases and other data-related tools as a standard, portable data format. Tabs and commas are the most common delimiters between columns, and linefeeds are the most common delimiters between rows.… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:delimited:limitations&rev=1467153531&do=diff Integration: Raw Data Files Delimited Files Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Limitations of Delimited Files Delimited files are often the most portable and flexible data file to be used, but they do have some limitations. These limitations are described below: text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:delimited:ofx&rev=1467153531&do=diff Integration: Raw Data Files Delimited Files Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Offset Indexes Delimited files have variable length rows, and this makes it difficult to locate a particular row. The offset for a particular row in a fixed-length file is easy to calculate by multiplying the record length times the row number. Delimited files require a different approach. Omnidex uses an Offset Index (OFX) to record th… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:delimited:options&rev=1467153531&do=diff Integration: Raw Data Files Delimited Files Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Options The OPTIONS clause of the CREATE TABLE statement is used to specify the column and record delimiters and other behavior or delimited files. The following options are supported: