This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:statements:load_ofx:home [2010/05/13 23:22] tdo |
dev:sql:statements:load_ofx:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| <html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | |||
| ====== Omnidex SQL: LOAD OFX ====== | ====== Omnidex SQL: LOAD OFX ====== | ||
| + | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| + | |||
| ===== Description ===== | ===== Description ===== | ||
| - | Load (generate) indexes for a Omnidex Snapshot character delimited table. | + | Load (generate) offset indexes for a Omnidex Snapshot or flatfile character delimited table. |
| + | |||
| + | The LOAD OFX statement is used to generate an index file containing record offsets that is used to provide fast file seek access into the Omnidex Snapshot. | ||
| - | The LOAD OFX statement is used to generate an index file that is used to provide fast file seek access into the Omnidex Snapshot since an Omnidex Snapshot is stored in standard Operating System files. | + | The LOAD OFX statement should only be used on tables within an Omnidex database declared with TYPE FILE. |
| ===== Syntax ===== | ===== Syntax ===== | ||