Browse Prior Art Database

Treat Database Field As Executable Command

IP.com Disclosure Number: IPCOM000100683D
Original Publication Date: 1990-May-01
Included in the Prior Art Database: 2005-Mar-16
Document File: 1 page(s) / 37K

Publishing Venue

IBM

Related People

Tate, BA: AUTHOR [+2]

Abstract

A program is disclosed that treats a database field as an OS/2* command. A new data type of 'Executable' is assigned to the field. When database rows are displayed in the context of a report or panel, then an icon, radio button, or similar input device is used to represent the data. When the user triggers the device, the database field is passed to the OS/2 command executor. Other database fields can be passed as parameters.

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

Treat Database Field As Executable Command

       A program is disclosed that treats a database field as an
OS/2* command.  A new data type of 'Executable' is assigned to the
field.  When database rows are displayed in the context of a report
or panel, then an icon, radio button, or similar input device is used
to represent the data.  When the user triggers the device, the
database field is passed to the OS/2 command executor.  Other
database fields can be passed as parameters.

      This interface gives an interactive query manager the ability
to represent more than numeric or character data. Some possibilities
include storing a command to display a graphic as one database field
and storing some graphic image in another. Another possibility is to
store a command that would play music and the music score.  Also, a
software vendor could demonstrate all software packages from an on-
screen report or some other interactive query output media.

      For example, let ART be a database table containing fields
(masterpiece, type, author, data) and let OS2EXE be a table
containing (type, command).  Assume that ART contains the following
row: ('Little Fugue', music, Bach, <musical score>) and OS2EXE
contains the following row: (music, PLAY.EXE). Now, assume that field
'command' is declared as type 'EXECUTABLE1', where the 1 means
'accept 1 parameter'. If the user runs the SQL query
     'Select masterpiece, command, data
     from ART,OS2EXE
     whe...