&<img src="../resources/images/opentocr.png" title="Open Contents list" border="0"&>
You are here:
4.3.11.1 Initial Example
4.3.11.2 More Efficient Example
Files Involved
Physical file PSLMST (personnel master file) has the following fields and an additional logical view called PSLMSTV1 keyed by SURNAME:
Field |
Type |
Length |
Description |
|---|---|---|---|
EMPNO |
S |
5 |
Employee number (primary key) |
GIVENAME |
A |
20 |
Given name |
SURNAME |
A |
20 |
Surname |
ADDRESS1 |
A |
30 |
Address line 1 |
ADDRESS2 |
A |
30 |
Address line 2 |
ADDRESS3 |
A |
30 |
Address line 3 |
|
&<img src="../resources/images/opentoc-dark.png" title="Open Contents List" border="0"&>