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

Simple Business Graphics Using Query Manager

IP.com Disclosure Number: IPCOM000106930D
Original Publication Date: 1992-Jan-01
Included in the Prior Art Database: 2005-Mar-21
Document File: 2 page(s) / 72K

Publishing Venue

IBM

Related People

Versteeg, A: AUTHOR

Abstract

The output of a SQL SELECT is not always optimal when using numerics only. Business graphics are much more effective in some cases.

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

Simple Business Graphics Using Query Manager

       The output of a SQL SELECT is not always optimal when
using numerics only. Business graphics are much more effective in
some cases.

      Simple business graphics can be displayed using standard QM and
DBM functions by joining the resulting numbers with a table that has
2 columns: numbers and corresponding bars.

      First create a table with 2 columns.  Column 1 is a smallint
column containing 0 through n, where n is the maximum bar size.
Column 2 is a fixed character column of length n+3.

      To populate this table create the following DELimited ASCII
file:
      0,"-"
      1,"X1"
      2,"XX2"
      3,"XXX3"
      etc.

      Replace the X with some ASCII character like 219 (solid block)
and import the ASCII file into a table that has been created using
the above field characteristics.

      Now Join the table that needs to be graphed with column 1 of
the 'bar' table. See the figure for a sample report.