Browse Prior Art Database

Method for Dynamically Handling Partial File Records

IP.com Disclosure Number: IPCOM000049620D
Original Publication Date: 1982-Jun-01
Included in the Prior Art Database: 2005-Feb-09
Document File: 5 page(s) / 18K

Publishing Venue

IBM

Related People

Batchelor, WL: AUTHOR [+3]

Abstract

The need for sophisticated programming support has delayed the application of computing systems to many problems, particularly those involving data base manipulation. Although considerable progress has been made in the attempt to provide computing systems which can be operated by a user who is not a programmer, these systems have limitations which limit their usefulness. One such limitation exists in a data base manipulation where required data has not been placed in the system. Such a situation arises where a new program is written for an existing data base which contains some, but not all, of the required information.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 39% of the total text.

Page 1 of 5

Method for Dynamically Handling Partial File Records

The need for sophisticated programming support has delayed the application of computing systems to many problems, particularly those involving data base manipulation. Although considerable progress has been made in the attempt to provide computing systems which can be operated by a user who is not a programmer, these systems have limitations which limit their usefulness. One such limitation exists in a data base manipulation where required data has not been placed in the system. Such a situation arises where a new program is written for an existing data base which contains some, but not all, of the required information. Instead of simply bringing the program to a halt in situations where required information is not in the data base, this system provides a series of prompting messages which lead the operator through a data entry routine to supply the missing data. Missing data could also be caused by the initial addition of an item to the data base through a program which required only limited information on the item. Use of the item by another program could require additional information on the same item.

For the purpose of this description it will be assumed that two programs, NEWHIRE and PAYROLL, exist and that these programs share a common data base consisting of a number of fields. Both programs utilize some common fields and some unique fields in the data base. Common Fields NEWHIRE Only PAYROLL Only

MANNO PHONENO EXEMPTIONS

SOCSECNO MS VACEARNED

EMPLOYEENAME JOBDESCRIPTION VACTAKEN

DEPTNO VACUSED

RATE HRSWORKED

WKGR0SS

WKFEDTAX

WKFICA

YTDGROSS

YTDFEDTAX

YTDSTATETAX

YTDFICA

OTHERDEDUCTIONS

WKNETPAY

The NEWHIRE program is for the purpose of entering into the data base the significant information about newly employed individuals and ensuring that no man numbers are duplicated. This latter action is achieved by changing the prompt sequence when the selected man number already exists in the data base. The new prompt sequence automatically displays those fields of the file record used by the program which are already known, while requesting the completion of those fields of the particular file record which are not known. The following example of an execution of the NEWHIRE program shows how fields would be added to the data base. Note that in the execution of the NEWHIRE job only those fields used by the NEWHIRE job are prompted for. The user (probably Personnel) is not required to be familiar with the payroll fields.

1

Page 2 of 5

N P I FUNCTIONS AVAILABLE 1. PROGRAM 2. FILES 3. RUN 4. SYSTEM

ENTER NUMBER OF SELECTED OPTION.
[]:

3

WHAT IS THE NAME OF THE JOB?

NEWHIRE ('*'NO MORE ENTRIES, '**' END JOB)

ENTER MANNO 111111
ENTER DEPNO 3 ('*'NO MORE ENTRIES, '**' END JOB)

ENTER MANNO 123456 ENTER SOCSECNO FOR MANNO 123456 298161424
ENTER EMPLOYEENAME FOR MANNO 123456 JOHN ROBERTS
ENTER PHONENO FOR MANNO 123456 2867287
ENTER MS FOR MANNO 123456
M
ENTER DEPTNO FOR MANNO 123456 020
ENTER JOB...