This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
tutorials:simple_flatfile [2009/12/05 18:15] tdo |
tutorials:simple_flatfile [2012/10/26 14:24] (current) |
||
|---|---|---|---|
| Line 14: | Line 14: | ||
| COLUMN mytext DATATYPE CHAR(60) | COLUMN mytext DATATYPE CHAR(60) | ||
| </code> | </code> | ||
| + | |||
| + | Use Notepad or any other text editor to create the Omnidex Environment source file. You can also select, cut and paste the text from this documentation to create the file. | ||
| This creates an Omnidex Environment named "tinyenv" with a single Database named "tinydb" with one table named "table1". Because the DATABASE TYPE is "flatfile", the name of the underlying operating system file for this table is "table1". Typically a filespec location would be used. Copy and save this environment as "tiny.src". | This creates an Omnidex Environment named "tinyenv" with a single Database named "tinydb" with one table named "table1". Because the DATABASE TYPE is "flatfile", the name of the underlying operating system file for this table is "table1". Typically a filespec location would be used. Copy and save this environment as "tiny.src". | ||
| Line 30: | Line 32: | ||
| > create file table1 | > create file table1 | ||
| + | |||
| + | OdxSQL contains several commands that facilitate with working with the underlying operating system without leaving OdxSQL. | ||
| > insert into table1 values (1) | > insert into table1 values (1) | ||
| + | |||
| + | Standard SQL INSERT statements are supported. | ||
| > select * from table1 | > select * from table1 | ||
| Line 221: | Line 227: | ||
| ### Note that Omnidex will do a quick text (Keyword) retreival automatically ## | ### Note that Omnidex will do a quick text (Keyword) retreival automatically ## | ||
| - | |||
| ==== Step 7 - Insert a new row to see that it is indexed ==== | ==== Step 7 - Insert a new row to see that it is indexed ==== | ||
| Line 237: | Line 242: | ||
| </code> | </code> | ||
| + | ==== Tutorial Summary ==== | ||
| + | By following these tutorial steps, you should have successfully: | ||
| + | * Created a Flat File Environment | ||
| + | * Created the file and inserted data. | ||
| + | * Used DBINSTAL to specify and build the Omnidex indexes. | ||
| + | * Performed Omnidex retrievals. | ||
| + | * Simulated a client/server environment with ODBC and OdxNet Network Services. | ||
| + | |||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||