Definition:An {ordered set} of {fields}, usually stored contiguously. The term is used with similar meaning in several different contexts. In a file, a "record" probably has some fixed length, in contrast to a "line" which may have any length and is terminated by some {End Of Line} sequence). A {database} record is also called a "row". In a {spreadsheet} it is always called a "row". Some programming languages use the term to mean a type composed of fields of several other types ({C} calls this a "{struct}"). In all these cases, a record represents an entity with certain field values. Fields may be of a fixed width ({bit}s or {characters}) or they may be separated by a {delimiter} character, often {comma} ({CSV}) or {HT} ({TSV}). In a database the list of values of a given field from all records is called a column. (2002-03-22).
http://www.learnthat.com/define/view.asp?id=6799
Example:, a single VSAM file stores both employee and address records. The correct record interpretation is managed by associating the value of a record type field with a record layout. The following COBOL definition shows how a REDEFINES clause specifies an alternate record type for ADDRESS-INFORMATION. If RECORD-TYPE = "A" Classic Data Architect uses the layout for address data.
01 EMPLOYEE-ADDRESS-RECORD. 05 EMP-ID PIC X(6). 05 RECORD-TYPE PIC X. 88 RECORD-IS-EMPLOYEE VALUE 'E'. 88 RECORD-IS-ADDRESS VALUE 'A'. 05 EMPLOYEE-INFORMATION. 10 LAST-NAME PIC X(20). 10 FIRST-NAME PIC X(20). 10 DATE-OF-BIRTH PIC 9(8). 10 MONTHLY-SALARY PIC S9(5)V99 COMP-3. 10 FILLER PIC X(48). 05 ADDRESS-INFORMATION REDEFINES EMPLOYEE-INFORMATION. 10 ADDRESS-LINE-1 PIC X(30). 10 ADDRESS-LINE-2 PIC X(30). 10 ADDRESS-CITY PIC X(20). 10 ADDRESS-STATE PIC XX. 10 ADDRESS-ZIP PIC 9(5).
Picture:
http://freepages.genealogy.rootsweb.ancestry.com/~donegalstrongs/ire_db.gif
Data Types:
Definition: The description of the kinds of data stored, passed and used.
http://www.ois.com/Products/glossary-of-terms.html#d
Data Types:
Definition: The description of the kinds of data stored, passed and used.
http://www.ois.com/Products/glossary-of-terms.html#d
Example and Picture:
Examine the differences between qualitative and quantitative data.
|
No comments:
Post a Comment