This is an old revision of the document!
Overview | Types | Creating | Maintaining | Deploying
There are two methods to create Omnidex Environments. They can be created interactively using the Omnidex Administrator, or they can be created using SQL statements such as CREATE ENVIRONMENT, CREATE DATABASE, CREATE TABLE and CREATE INDEX.
Once created, a simple Omnidex Environment File will look like this:
create environment in "simple.xml" with delete; create database "SIMPLE" type FLATFILE index_directory "idx" in "simple.xml"; create table "HOUSEHOLDS" physical "dat\households.dat" ( "HOUSEHOLD" CHARACTER(12), "ADDRESS" CHARACTER(50), "CITY" CHARACTER(28), "STATE" CHARACTER(2), "ZIP" CHARACTER(5), "COUNTRY" CHARACTER(2), constraint HSHD_HOUSEHOLD_PK primary ("HOUSEHOLD"), constraint HSHD_STATE_FK foreign ("STATE") references "STATES", constraint HSHD_COUNTRY_FK foreign ("COUNTRY") references "COUNTRIES" ) in "simple.xml"; create table "INDIVIDUALS" physical "dat\individuals.dat" ( "INDIVIDUAL" CHARACTER(12), "HOUSEHOLD" CHARACTER(12), "NAME" CHARACTER(50), "GENDER" CHARACTER(1), "BIRTHDATE" ANSI DATE, "PHONE" CHARACTER(14), "EMAIL" CHARACTER(60), constraint IND_INDIVIDUAL_PK primary ("INDIVIDUAL"), constraint IND_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS", constraint IND_GENDER_FK foreign ("GENDER") references "GENDERS", ) in "simple.xml";
See also: