Introduction › DataManager Concepts and Terms

DataManager Concepts and Terms

DataManager builds a relational database that consists of definition tables which are two-dimensional arrays of rows and columns. Each row stores a separate record. Each column has a name (like City, State or Zipcode) and stores similar data values (numeric or character, for example). Columns are often referred to as fields.

Here is a sample table:

         CITY      STATE   ZIPCODE
Row 1    Boston    MA      02120
Row 2    New York  NY      10016
Row 3    Dallas    TX      75217
Row 4    Phoenix   AZ      85012

Definition Tables contain records that describe DataManager's input and output.

Table Name

Description

IRDDESC

(Input Record Description Table): Specifies the description, record length, and record name for every defined input record.

IRDTAB

(Input Record Definitions Table): Specifies the definition for each field within an input record.

ORDDESC

(Output Record Description Table): Specifies the description of each output record, including the name of the input record from which it is derived.

ORDTAB

(Output Record Definitions Table): Specifies the definition for each field within an output record.

DataManager's online component consists of panels for defining and maintaining the records in these tables. Once you've set up these tables, they require minimal maintenance.