Browse Prior Art Database

Column Name Prompting When Saving Report Data to a New Table

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

Publishing Venue

IBM

Related People

Authors:
Ballard, DJ Bracht, CJ Stephens, CA [+details]

Abstract

Disclosed is a method which allows users to save Structured Query Language Select Data in a new table with column names that are unique, yet meaningful. On Query Manager, a user is able to query for data using a Structured Query Language Select statement. The resulting data can be saved as a new table. To create a table for the data, a table name and the column names within the table must be specified. Column names within the table must be unique. However, the statement used to query for data can contain references to columns in different tables with the same column name. See Fig. 1. If this occurs, the column name uniqueness in the new table must still be maintained.