Browse Prior Art Database

Method for Porting Third-Party Data-Intensive Applications to Advanced DB/2 Platforms

IP.com Disclosure Number: IPCOM000104898D
Original Publication Date: 1993-Jun-01
Included in the Prior Art Database: 2005-Mar-19
Document File: 2 page(s) / 47K

Publishing Venue

IBM

Related People

Clark, DK: AUTHOR [+3]

Abstract

A program is described which converts arbitrary customer database products/operations into an Operating System/2* Database/2* (OS/2* DB/2*) product or operation, regardless of customization requirements. Customers will be able to convert old methods of storing data into a portable DB/2 method.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 67% of the total text.

Method for Porting Third-Party Data-Intensive Applications to Advanced DB/2 Platforms

      A program is described which converts arbitrary customer
database products/operations into an Operating System/2* Database/2*
(OS/2* DB/2*) product or operation, regardless of customization
requirements.  Customers will be able to convert old methods of
storing data into a portable DB/2 method.

      This article describes converting a database, whether it be a
flat file with designated columns, a binary format or another type of
database format into a DB/2 database along with supporting
Input/Output Application Programming Interface (I/O API) code.  The
source format is fed into the program as a set of rules which
describes the source database format.  Based on said rules, the
program generates Standard Query Language (SQL) code to create
tables, read from the table(s), insert into the table(s), update the
table(s), and delete from the table(s).  A forward declaration header
file and other necessary header files are generated to facilitate
customized database development.  Once the SQL code is generated, the
program binds the create-table module(s) to a newly created database
(name chosen) and creates the table(s).  Upon successful creation,
the source file is parsed and data is gathered and placed into the
new DB/2 tables.  When completed, the entire source data has been
placed into a DB/2 database and a complete database I/O application
programming interface has be...