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/11 00:14] tdo removed |
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 ===== | ||
- | ===== Syntax ===== | + | Load (generate) offset indexes for a Omnidex Snapshot or flatfile character delimited table. |
- | Load indexes for a 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 should only be used on tables within an Omnidex database declared with TYPE FILE. | ||
+ | |||
+ | ===== Syntax ===== | ||
<code> | <code> | ||
Line 13: | Line 18: | ||
[ON [INSTANCE] instance] | [ON [INSTANCE] instance] | ||
[WITH options] | [WITH options] | ||
- | </code> | + | </code> |
- | |||
===== Discussion ===== | ===== Discussion ===== | ||