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]] |