This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
dev:sql:statements:create_environment:home [2010/07/02 08:05] tdo |
dev:sql:statements:create_environment:home [2010/07/02 19:56] els |
||
---|---|---|---|
Line 49: | Line 49: | ||
The NODE clause declares a node in an Omnidex Grid. Nodes can then be referenced in subsequent CREATE DATABASE and CREATE TABLE statements. | The NODE clause declares a node in an Omnidex Grid. Nodes can then be referenced in subsequent CREATE DATABASE and CREATE TABLE statements. | ||
+ | |||
+ | The //node_name// uniquely identifies the node within this environment. It may be up to 32 characters long, and can contain letters, digits and the following special characters: ! @ # $ % ^ _. It must begin with a letter and is case-insensitive. The //node_name// must be unique within the environment. | ||
=== <PARTITIONED | UNPARTITIONED> === | === <PARTITIONED | UNPARTITIONED> === | ||
Line 105: | Line 107: | ||
==== IN "filename" ==== | ==== IN "filename" ==== | ||
- | The IN clause is required and specifies the location of the physical XML Environment File. | + | The IN clause is required and specifies the location of the physical XML Environment File. The IN clause must be specified after all other clauses except the WITH clause. |
- | + | ||
- | The IN clause must be specified after all other clauses except the WITH clause. | + | |
- | The filespec can be specified either as an absolute or a relative file specification. When using a relative file specification, it will be relative to the current working directory for the program that is being run. Typically in a production environment, absolute filespecs are used. When using Omnidex's Network Services and the OdxNet process, absolute filespecs should always be used. | + | //Filename// can also include either an absolute or relative path. When using a relative file path , it will be relative to the current working directory for the program that is being run. Typically in a production environment, absolute paths are used. When using Omnidex's Network Services and the OdxNet process, absolute paths should always be used. |
- | The IN filespec must be enclosed within double quotes. | + | The //filename// must be enclosed within double quotes. |
<code> | <code> |