Omnidex SQL: CREATE ENVIRONMENT

CREATE ENVIRONMENT command will create an Omnidex Environment which represents Omnidex's view of a collection of data used for indexing and retrieval.

An Omnidex Environment may be a complete or partial mapping to a relational data base, a collection of multiple data bases or a mapping to one or more flat files,

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.

Default year if not specified

• PARTITION and UNPARTITIONED
• HOST
  • PORT
• ENVIRONMENT

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

CREATE ENVIRONMENT daily_transactions 
  CENTURY_THRESHOLD 10
  IN "C:\data\daily_trans";

SET CONTINUATION OFF
DROP ENVIRONMENT xxx;
CREATE ENVIRONMENT myenv IN "C:\data\myenv";
CREATE DATABASE
CREATE TABLE
CREATE TABLE
CREATE INDEX