Omnidex Environments

POSIX Flat Files

Defining Tables | Installing Indexes on Parent Tables

Omnidex supports read access to stream or "flat" files containing fixed-length records on UNIX. You can index and retrieve data using Omnidex keys, but the OmniAccess routines oainsert, oadelete and oaupdate do not support flat files. To update the Omnidex indexes in real time in conjunction with flat file updates, use the routines oainsertindex, oaupdateindex and oadeleteindex.

ENVIRONMENT ORDERS

DATABASE "ORDERS"

TYPE FLATFILE

Defining Tables

When declaring tables for flat files, a table TYPE statement is not required. Declare a PHYSICAL statement that gives the path and file name of the data files.

Installing Indexes on Parent Tables

When you installed the demonstration database, you ran DBINSTAL using the script file ordersin.ffl. This script file contained commands to install indexes for the tables in the database.

Because POSIX flat files have no underlying index to provide access to a parent file by its unique key, ordersin.ffl appended the TRR option when installing keyword keys on each parent table.

Consequently, when you install MDK keys on parent tables for your own POSIX databases, you must also append the TRR option. Invoke the TRR option by appending it to your TABLE name when replying to the DBINSTAL Table name? prompt. For example:

DS76004.3.3 Omnidex IMS DBINSTAL Wed Feb 15 15:23:46 1995
(C) Dynamic Information Systems Corp. 1981

Data base name: ordersec.env

Cmd: i

OMNIDEX INSTALLATION:

Designate tables and fields for KEYWORD retrieval.
Type / to stop; type ? for help.

Table name? CUSTOMERS;TRR

Keyword field: COMPANY;G1
Keyword field: CONTACT;G1;SX

top