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 [2011/03/14 22:42] tdo |
dev:sql:statements:create_database:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 56: | Line 56: | ||
| create database "LIST" | create database "LIST" | ||
| - | type FLATFILE | + | type FILE |
| index_directory "idx" | index_directory "idx" | ||
| in "list.xml"; | in "list.xml"; | ||
| Line 75: | Line 75: | ||
| create database "LIST" | create database "LIST" | ||
| node "GRID01" | node "GRID01" | ||
| - | type FLATFILE | + | type FILE |
| index_directory "idx\grid01" | index_directory "idx\grid01" | ||
| node "GRID02" | node "GRID02" | ||
| - | type FLATFILE | + | type FILE |
| index_directory "idx\grid02" | index_directory "idx\grid02" | ||
| node "GRID03" | node "GRID03" | ||
| - | type FLATFILE | + | type FILE |
| index_directory "idx\grid03" | index_directory "idx\grid03" | ||
| node "GRID04" | node "GRID04" | ||
| - | type FLATFILE | + | type FILE |
| index_directory "idx\grid04" | index_directory "idx\grid04" | ||
| node "GRID05" | node "GRID05" | ||
| - | type FLATFILE | + | type FILE |
| index_directory "idx\grid05" | index_directory "idx\grid05" | ||
| in "list.xml"; | in "list.xml"; | ||
| Line 97: | Line 97: | ||
| Valid database types are: | Valid database types are: | ||
| - | * FLATFILE | + | * FILE |
| * ORACLE | * ORACLE | ||
| * SQLSERVER | * SQLSERVER | ||
| Line 123: | Line 123: | ||
| <code> | <code> | ||
| create database "LIST" | create database "LIST" | ||
| - | type FLATFILE | + | type FILE |
| index_directory {$LIST_DIR} | index_directory {$LIST_DIR} | ||
| </code> | </code> | ||
| Line 148: | Line 148: | ||
| The PHYSICAL //rdbms_string// declares RDBMS connection information and is only used with relational databases and ODBC. The //rdbms_string// varies according to database type as follows: | The PHYSICAL //rdbms_string// declares RDBMS connection information and is only used with relational databases and ODBC. The //rdbms_string// varies according to database type as follows: | ||
| ^Database Type ^Description ^ | ^Database Type ^Description ^ | ||
| - | | FLATFILE | ignored | | + | | FILE | ignored | |
| | ORACLE | The PHYSICAL clause is ignored and Oracle will use the default database for the specified user. | | | ORACLE | The PHYSICAL clause is ignored and Oracle will use the default database for the specified user. | | ||
| | ORACLE w/SQLNET | if using Oracle SQLNET, use the name of the SQLNET service and specify "SQLNETx" in the VERSION clause. | | | ORACLE w/SQLNET | if using Oracle SQLNET, use the name of the SQLNET service and specify "SQLNETx" in the VERSION clause. | | ||
| Line 233: | Line 233: | ||
| Articles: | Articles: | ||
| - | * [[admin:grids:home|Omnidex Grids]] | + | * [[admin:features:grids:home|Omnidex Grids]] |
| * [[dev:appendix:articles:dbspecific:home|Database-specific issues]] | * [[dev:appendix:articles:dbspecific:home|Database-specific issues]] | ||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||