Omnidex SQL: CREATE ENVIRONMENT

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

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

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