Browse Prior Art Database

Foreign Column Specification for Database Import/Export

IP.com Disclosure Number: IPCOM000034602D
Original Publication Date: 1989-Mar-01
Included in the Prior Art Database: 2005-Jan-27

Publishing Venue

IBM

Related People

Authors:
Alexander, VL Jordan, LE Sandve, SM [+details]

Abstract

Disclosed are methods for a user to control the selection of columns of data from a foreign file when importing data from the foreign file into a relational database, and means for the user to rename columns when exporting data from a database into the foreign file for migrating data to another system. The methods described herein apply to import and export utilities which are part of a relational database software product and are used as a means of migrating data from other systems, databases, or various software products into the relational database software product, and from databases of the relational software product into other systems, products and databases. One of the control parameters for the import and export utilities is the address of a table giving information about columns in the foreign data file.