This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:statements:create_database:home [2010/07/06 23:12] els |
dev:sql:statements:create_database:home [2012/10/26 15:00] (current) |
||
|---|---|---|---|
| Line 102: | Line 102: | ||
| * ODBC | * ODBC | ||
| - | When a database is spread across multiple nodes of an Omnidex Grid, the PHYSICAL clause is declared for each node. At present, the //database_type// must be the same across all nodes; however, support for different database types for each node may be supported in the future. | + | When a database is spread across multiple nodes of an Omnidex Grid, the PHYSICAL clause is declared for each node. The //database_type// must be the same across all nodes. |
| === SUBTYPE odbc_subtype === | === SUBTYPE odbc_subtype === | ||
| Line 119: | Line 119: | ||
| If no //directory// is declared, then the Omnidex index files will reside in the same directory as the Omnidex Environment File. | If no //directory// is declared, then the Omnidex index files will reside in the same directory as the Omnidex Environment File. | ||
| + | The //directory// can also be specified with an environment variable using curly braces. | ||
| + | |||
| + | <code> | ||
| + | create database "LIST" | ||
| + | type FLATFILE | ||
| + | index_directory {$LIST_DIR} | ||
| + | </code> | ||
| === VERSION “rdbms_version” === | === VERSION “rdbms_version” === | ||
| Line 223: | Line 230: | ||
| * [[dev:sql:statements:create_index:home|CREATE INDEX]] | * [[dev:sql:statements:create_index:home|CREATE INDEX]] | ||
| * [[dev:sql:statements:update_indexes:home|UPDATE INDEXES]] | * [[dev:sql:statements:update_indexes:home|UPDATE INDEXES]] | ||
| - | |||
| - | Articles: | ||
| - | |||
| - | * [[admin:grids:home|Omnidex Grids]] | ||
| - | * [[dev:appendix:articles:dbspecific:home|Database-specific issues]] | ||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||