Record (File architecture)

From m204wiki
Revision as of 22:38, 20 March 2013 by Rob (talk | contribs) (Created page with "A Model 204 Record is a collection of fields (either individually or in Repeating Field Groups (RFGs). Each record is variable in length and need contain only the fields that...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

A Model 204 Record is a collection of fields (either individually or in Repeating Field Groups (RFGs).

Each record is variable in length and need contain only the fields that pertain to it. The limit of the number of field value pairs in a record is in the tens of millions.

There is only a limited fixed format for a record (pre-allocated fields). Almost any number of fields can appear almost any number of times in almost any order. Each record is automatically assigned a unique internal record number that is used by the system to build index entries for the record.


The Concept of a Model 204 Record

Base Records

Extension Records

The Structure of a Model 204 Record

Pre-allocated Fields

Field Value Pairs

Repeating Field Groups

Large Objects

Native Large Objects

Large Objects Without Table E