Browse Prior Art Database

SQL Statement Library List

IP.com Disclosure Number: IPCOM000103596D
Original Publication Date: 1993-Jan-01
Included in the Prior Art Database: 2005-Mar-18
Document File: 2 page(s) / 70K

Publishing Venue

IBM

Related People

Li, ST: AUTHOR [+2]

Abstract

Disclosed is a library list to allow the user to maintain and use SQL statements that were previously created and saved. Otherwise, when a user creates a SQL statement, it is either lost after execution or stored separately as an individual object. In such cases, the user lacks a quick and consistent user interface in which the user can store and view the SQL statements that he or she created or obtained from other users.

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

SQL Statement Library List

       Disclosed is a library list to allow the user to maintain
and use SQL statements that were previously created and saved.
Otherwise, when a user creates a SQL statement, it is either lost
after execution or stored separately as an individual object.  In
such cases, the user lacks a quick and consistent user interface in
which the user can store and view the SQL statements that he or she
created or obtained from other users.

      With many products, such as Query Manager, when a user creates
a SQL statement and saves it, the statement is saved as an individual
object; a saved object cannot contain more than one SQL statement.
In these situations, the user is forced to individually open and scan
through each object in order to determine whether or not the user
wants to reuse it or if the user should create a new statement.
Neither can these objects be easily combined.  If these statements
were stored in a library list, the user could quickly scan through
all the stored statements and select one or more of these statements
to create a SQL statement that could be executed or saved as a
separate object.

      The SQL library list contains multiple entries with each entry
storing a SQL statement.  In this list, SQL statements can be saved
and retrieved for later use.  Internally, the library list keeps the
list sorted in historical order, but the user can sort the list
alphabetically (to see all the SELECT statements together, for
example) and revert to historical ordering at a later time, or t...