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_environment:home [2010/07/06 22:50] els |
dev:sql:statements:create_environment:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 15: | Line 15: | ||
| [ NODE node_name | [ NODE node_name | ||
| [ <PARTITIONED | UNPARTITIONED> ] | [ <PARTITIONED | UNPARTITIONED> ] | ||
| - | [ HOST <host_name | host_ip_address | LOCALHOST> [ PORT port_number ] ] | + | [ CONNECTIONSTRING "filespec" ] ] |
| - | [ ENVIRONMENT “filespec” ] ] | + | |
| [ SQL_SYNTAX < OMNIDEX | ORACLE | SQLSERVER > ] | [ SQL_SYNTAX < OMNIDEX | ORACLE | SQLSERVER > ] | ||
| [ CENTURY_THRESHOLD year ] | [ CENTURY_THRESHOLD year ] | ||
| IN “filename” /* must be after all previous clauses */ | IN “filename” /* must be after all previous clauses */ | ||
| [WITH options] /* if used, must be the very last clause */ | [WITH options] /* if used, must be the very last clause */ | ||
| + | |||
| ===== Discussion ===== | ===== Discussion ===== | ||
| The CREATE ENVIRONMENT statement can be used in conjunction with the [[dev:sql:statements:drop_environment:home | DROP ENVIRONMENT]] statement but typically the WITH DELETE option is used instead of DROP ENVIRONMENT. | The CREATE ENVIRONMENT statement can be used in conjunction with the [[dev:sql:statements:drop_environment:home | DROP ENVIRONMENT]] statement but typically the WITH DELETE option is used instead of DROP ENVIRONMENT. | ||
| Line 169: | Line 169: | ||
| Articles: | Articles: | ||
| - | * [[admin:grids:home|Omnidex Grids]] | + | * [[admin:features:grids:home|Omnidex Grids]] |