4.3.11 Page At a Time Scrolling (Forward Only)

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