User guide

Connecting Record Descriptions to Form New Relationships
Developing an ENFORM Query
3–14 058058 Tandem Computers Incorporated
ENFORM builds the logical record occurrences from the record occurrences shown in
Figure 3-8. ENFORM then produces the target records also shown in that figure.
Figure 3-8. Report Produced When Both LINK OPTIONAL and WHERE Clause Specified
regnum
99
2
5
5
6
2
• • •
4
Logical Record Occurrences Built for the Link
Employee Record Occurrences
regnum
99
2
5
5
7
6
2
• • •
4
empname
ROGER GREEN
JERRY HOWARD
THOMAS RUDLOFF
PAUL WINTER
MARK MONTEMORRA
SUSAN HENDERSON
DAVID STRAND
• • •
ALAN TERRY
Region Record Occurrences
regnum
1
2
3
4
5
6
99
regname
EAST
CENTRAL
WEST
CANADA
GERMANY
ENGLAND
HEADQUARTERS
empnum
1
23
32
43
49
65
104
• • •
343
regnum
99
2
5
5
7
6
2
• • •
4
empname
ROGER GREEN
JERRY HOWARD
THOMAS RUDLOFF
PAUL WINTER
MARK MONTEMORRA
SUSAN HENDERSON
DAVID STRAND
• • •
ALAN TERRY
regname
HEADQUARTERS
CENTRAL
GERMANY
GERMANY
ENGLAND
CENTRAL
• • •
CANADA
empnum
1
23
32
43
49
65
104
• • •
343
empname
THOMAS RUDLOFF
PAUL WINTER
MARK MONTEMORRA
regname
GERMANY
GERMANY
Target Records