This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:create_environment [2009/11/25 05:49] tdo |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | ====== Omnidex SQL: CREATE ENVIRONMENT ====== | ||
| - | ===== Description ===== | ||
| - | ===== Syntax ===== | ||
| - | 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 ] | ||
| - | ===== Discussion ===== | ||
| - | == ENVIRONMENT environment_name == | ||
| - | 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. | ||
| - | |||
| - | == CENTURY_THRESHOLD year == | ||
| - | |||
| - | 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. | ||
| - | |||
| - | FIXME Default year if not specified | ||
| - | |||
| - | == DATA_CACHE == | ||
| - | == METADATA_CACHE == | ||
| - | == MAX_THREADS == | ||
| - | == NODE == | ||
| - | * PARTITION and UNPARTITIONED | ||
| - | * HOST | ||
| - | * PORT | ||
| - | * ENVIRONMENT | ||
| - | == IN "filespec" == | ||
| - | |||
| - | == WITH options == | ||
| - | |||
| - | ===== Examples ===== | ||
| - | ==== Simple ==== | ||
| - | |||
| - | CREATE ENVIRONMENT daily_transactions IN "C:\data\daily_trans.xml" | ||
| - | ==== Century Threshold ==== | ||
| - | |||
| - | CREATE ENVIRONMENT daily_transactions | ||
| - | CENTURY_THRESHOLD 10 | ||
| - | IN "C:\data\daily_trans.xml"; | ||
| - | |||
| - | ==== Nodes ==== | ||
| - | ==== In an OdxSQL Script ==== | ||
| - | |||
| - | SET CONTINUATION OFF | ||
| - | DROP ENVIRONMENT xxx; | ||
| - | CREATE ENVIRONMENT myenv IN "C:\data\myenv"; | ||
| - | CREATE DATABASE | ||
| - | CREATE TABLE | ||
| - | CREATE TABLE | ||
| - | CREATE INDEX | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||