Pyramid Computing, Inc.
Implementing creative solutions efficiently
       
   

Search

  Pyramid Computing, Inc.
  333 Red Lily Place
  Evergreen, CO  80439

  720-515-9332  Voice
  720-528-8166  Fax

 
 

Up

Coca-Cola Foods - Billing & Promotions System Downsizing

Client Project / Industry Role / Skills Used
Coca-Cola Foods
Houston, Texas
Mainframe Downsizing
Manufacturing Food
Project DBA
MicroFocus COBOL, Oracle, Novell

Functioned as Project DBA and System Architect during the downsizing of this project. The project used over 140 database tables that occupy 12GB of storage. Developed software to maintain duplicate read-only copies on the PC/LAN of 30 databases that were maintained on the Mainframe in Datacom/DB. This process is completely data driven and consists of a Mainframe extract program and a PC database update program. Changes are detected on the Mainframe, the changed records from each table are extracted and sent to the PC along with the copybook for the table. The PC update program processes the copybook and builds an internal table that maps the input data fields and data types. It then uses the SQL dictionary tables to dynamically create an Update or Insert command with the data from the mainframe extract record. It also performs a full database record count comparison and hash-total to ensure that the databases are in sync.