Omnidex SQL: CREATE ENVIRONMENT

CREATE ENVIRONMENT environment_name
  [ CENTURY_THRESHOLD year ]
  [ DATA_CACHE int ]
  [ METADATA_CACHE int ]
  [ MAX_THREADS int ]
  [ NODE node_name 
    [ <PARTITIONED | UNPARTITIONED> ]
    [ HOST <LOCALHOST | host_name | host_ip_address>  
      [ PORT port_number ] ]
    [ ENVIRONMENT “filespec” ] ]
   IN “filespec”
   [ WITH options ] 

The environment_name is a logical name for the environment. It is only used when fully declaring a table or database name, using the syntax, “environment.database.table” or environment.database. The environment_name has a maximum of 32 characters and must start with a letter.

The century threshold determines whether a year that is expressed without the century (such as 12/31/80) is recognized as being in the current century (12/31/2080) or in the previous century (12/31/1980). Years that are later than the century threshold are considered part of the last century while years that are earlier than the century threshold are considered part of the current century.

• PARTITION and UNPARTITIONED
• HOST
  • PORT
• ENVIRONMENT

CREATE ENVIRONMENT daily_transactions IN "C:\data\daily_trans.xml"

CREATE ENVIRONMENT daily_transactions 
  CENTURY_THRESHOLD 1950
  IN "C:\data\daily_trans.xml";