https://www.omnidex.com/docs/v54/ 2026-08-03T20:59:15+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:ost:datatypes&rev=1467153531&do=diff Integration: Raw Data Files Omnidex Standalone Tables Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Datatypes The record layout described in the CREATE TABLE statement must exactly match the order, datatype, and length of columns in the Omnidex Standalone Table. If these record layouts do not match, Omnidex will return an error when the table is accessed. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:ost:environments&rev=1467153531&do=diff Integration: Raw Data Files Omnidex Standalone Tables 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. Omnidex Standalone Tables have metadata about the table itself, but not the table relationships or the Omnidex indexing. 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:ost:example&rev=1467153531&do=diff Integration: Raw Data Files Omnidex Standalone Tables Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Example The following example is a simple database using Omnidex Standalone Tables. 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:ost:export&rev=1467153531&do=diff Integration: Raw Data Files Omnidex Standalone Tables Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | 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. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:ost:home&rev=1467153531&do=diff Integration: Raw Data Files Omnidex Standalone Tables Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Overview Omnidex Standalone Tables are a propritary storage format that combines metadata, data, and native indexes into portable files. The most common use of Omnidex Standalone Tables is to allow data to be easily transported and dynamically attached as temporary tables to any environment; however, Omnidex Standalone Tables c… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:ost:limitations&rev=1467153531&do=diff Integration: Raw Data Files Omnidex Standalone Tables Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Limitations of Omnidex Standalone Tables Omnidex Standalone Tables are full-featured and flexible, and have few limitations. Fixed-length files may provide higher performance if they do not have large textual columns, and delimited files may be more common, but Omnidex Standalone Tables represent the best features of both of the… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:ost:ofx&rev=1467153531&do=diff Integration: Raw Data Files Omnidex Standalone Tables Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Offset Indexes Omnidex Standalone Tables may also be paired with an Offset Index. An Offset Index records the offset for each row in a file, and is useful when there is compressed or variable-length records in a file. If the option COMPRESSION=OFF is used when the Omnidex Standalone Table is created, no Offset Index will be cre… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rawdata:ost:options&rev=1467153531&do=diff Integration: Raw Data Files Omnidex Standalone Tables Overview | Environments | Options | Datatypes | Offset Indexes | Exporting | Limitations | Example ---------- Options Used in CREATE TABLE Statements The OPTIONS clause of the CREATE TABLE statement is used to indicate that these files are Omnidex Standalone Tables. The only option used in this clause is the OST option described below: