Browse Prior Art Database

POWER TOOLS

IP.com Disclosure Number: IPCOM000036369D
Original Publication Date: 1989-Sep-01
Included in the Prior Art Database: 2005-Jan-29
Document File: 4 page(s) / 76K

Publishing Venue

IBM

Related People

Johnson, PM: AUTHOR

Abstract

POWER TOOLS is a programming device allowing several application programs to interactively address a common database workspace in Structured Query Language/Data System (SQL/DS) to provide current information on product status. The application programs are written in Restructured Extended Executor (REXX) using XEDIT as the editor with Display Management System/Conversational Monitor System (DMS/CMS) PANEL to create the screens. PANEL is an EXEC used by DMS/CMS to create "menus" and "screens." The software patch between REXX and SQL is accomplished with the use of RXSQL, a program patch between REXX and SQL in Virtual Machine/System Product (VM/SP). The individual applications can be defined by the end user to simplify and consolidate data manipulation.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 50% of the total text.

Page 1 of 4

POWER TOOLS

POWER TOOLS is a programming device allowing several application programs to interactively address a common database workspace in Structured Query Language/Data System (SQL/DS) to provide current information on product status. The application programs are written in Restructured Extended Executor (REXX) using XEDIT as the editor with Display Management System/Conversational Monitor System (DMS/CMS) PANEL to create the screens. PANEL is an EXEC used by DMS/CMS to create "menus" and "screens." The software patch between REXX and SQL is accomplished with the use of RXSQL, a program patch between REXX and SQL in Virtual Machine/System Product (VM/SP). The individual applications can be defined by the end user to simplify and consolidate data manipulation. For example, the ENDICOTT POWER DEVELOPMENT LAB uses POWER TOOLS with the following applications:

CROSS REFERENCE is a program which tracks the conversion of generic part numbers to IBM part numbers. This permits the generic vendor part number information to be readily available when substitution is required.

SURPLUS PARTS NETWORK (SPN) is a database of surplus parts consisting of both IBM and vendor part numbers and is made available via the SPN bulletin board on VM/SP. This program provides a real-time listing of all surplus parts that are available for use by other departments. There is no cost associated with the procurement of surplus parts from the department that advertises them for use. Instead, because the parts are already paid for, the surplus parts are free. This eliminates Interplant Transfer (IPT) of funds generation and the delay associated with procurement from the CORPORATE Surplus List.

BILL OF MATERIAL is a development tool that initializes the bills of materials for new products which tracks IBM part numbers, vendor part numbers, quantities, prices, purchase order numbers, engineering change activities, component designations, descriptions, etc. This data collection tool enables the user to check the progress of parts ordering activity during the early phases of development. This system can also be used by EARLY MANUFACTURING INVOLVEMENT teams to preview the parts set for new products. Because Development Product Record System (DPRS) is a much slower manufacturing tool, BILL OF MATERIAL can be a real-time window to development efforts.

PURCHASE ORDER STATUS is a data extraction from the MASTER PURCHASE ORDER (MPO) file. The data in this application shows the purchase order activities from the initial order placement through the receiving of the items purchased. The data from this program can be used in the BILL OF MATERIAL program to aid in the traceability of early development parts procurement.

BLUE PRINT ORDER is an on-line blue print request tool and does not use the SQL database but is included in POWER TOOLS because of its important role in early development.

1

Page 2 of 4

VIDMAR PARTS is an inventory program that indicates the part numbers of it...