This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
integration:rawdata:ost:datatypes [2011/03/14 14:21] 127.0.0.1 external edit |
integration:rawdata:ost:datatypes [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 ====== |
===== Omnidex Standalone Tables ===== | ===== Omnidex Standalone Tables ===== | ||
Line 20: | Line 20: | ||
==== Datatypes ==== | ==== 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. | + | 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. |
Omnidex Standalone Tables support all of the Omnidex datatypes. The datatype restrictions that exist for fixed-length files and delimited files do not exist for Omnidex Standalone Tables. | Omnidex Standalone Tables support all of the Omnidex datatypes. The datatype restrictions that exist for fixed-length files and delimited files do not exist for Omnidex Standalone Tables. | ||
- | The internal schema of the OST can be viewed using one of two methods. It is possible to view the column layout for an Omnidex Standalone Table by attaching it to an environment using the [[dev:sql:statements:attach|ATTACH]] command and then using the [[programs:odxsql:commands:show|SHOW TABLE]] command. | + | The internal schema of the OST can be viewed using one of two methods. It is possible to view the column layout for an Omnidex Standalone Table by attaching it to an environment using the [[dev:sql:statements:attach|ATTACH]] statement and then using the [[programs:odxsql:commands:show|SHOW TABLE]] statement. |
<code> | <code> | ||
Line 87: | Line 87: | ||
\\ | \\ | ||
- | More detailed information about the Omnidex Standalone Table can be seen using the [[programs:odxsql:commands:dump_ost|DUMP OST]] command in OdxSQL. This command will dump the metadata for the OST as well as the each row, printed in hex and character. | + | More detailed information about the Omnidex Standalone Table can be seen using the [[programs:odxsql:commands:dump_ost|DUMP OST]] statement in OdxSQL. This command will dump the metadata for the OST as well as the each row, printed in hex and character. |
<code> | <code> |