Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
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
Document File: 2 page(s) / 71K

Publishing Venue

IBM

Related People

Ballard, DJ: AUTHOR [+3]

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.

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 100% of the total text.

Page 1 of 2

Column Name Prompting When Saving Report Data to a New Table

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.

(Image Omitted)

Every time data from a Structured Query Language Select statement is to be saved in a new table, the user would be prompted for the column names for the new table. See Fig. 2. Default column names will be displayed based on column names from the Structured Query Language Select statement. The data types and attributes of each column are displayed to aid the user. This allows the user the flexibility to override defaulted column names to provide more meaningful column names.

1

Page 2 of 2

2

[This page contains 4 pictures or other non-text objects]