Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2003
    Posts
    18

    Arrow Unanswered: Web Report Tool for DB2

    Hi NG,

    does anyone have a suggestion for a tool that would provide very basic, read-only access to a DB2 database through a simple HTML-form? The idea is to allow the customer without any SQL- or database-knowledge to access the database only with a web browser.
    This tool schould be able to create customized reports, as well as HTML-forms and dialogs based on the information retrieved from the database.

    Movie-DB-Example:

    _MOVIE_|_ACTOR_|_CHARACTER_

    _StarTrek_|_Patrick Stewart_|_Captain Jean-Luc Picard_
    _X-Men_|_Hugh Jackman_|_Logan/Wolverine_
    _X-Men_|_Patrick Stewart_|_Professor Charles Xavier_


    (1)The tool automatically runs

    select DISTINCT movie
    from movie-db;

    and creates a form:

    --------------
    Select Movie:
    ( ) StarTrek
    ( ) X-Men
    --------------

    (2) The customer selects (x) X-Men and clicks "Next".
    As the result, the tool automatically runs

    select DISTINCT actor
    from movie-db
    where movie='X-Men';

    and creates a form

    --------------------
    Select Actor
    ( ) Patrick Stewart
    ( ) Hugh Jackman
    --------------------

    If the customer selects (x) Patrick Stewart, the tool schould generate a report in form of a HTML-Table like this:

    _MOVIE__|_ACTOR_|_CHARACTER_
    _X-Men_|_Patrick Stewart_|_Professor Charles Xavier_


    Appreciate everyones help!!!

    Thanks in Advance,

    S.B.
    Last edited by stefanB; 10-20-03 at 08:58.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •