HP3000-L Archives

March 2003, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Robert Mills <[log in to unmask]>
Reply To:
Robert Mills <[log in to unmask]>
Date:
Thu, 13 Mar 2003 14:52:04 -0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (154 lines)
Alfredo,

Thank you for the offer of a download of DBHTML which I'll have to decline.
I've found version 2000-11-30 on our system which I'd forgotten about
(thanks for reminding me about the utility).

regards,

Robert W.Mills
Systems Development Manager
Windsong Services
(01689) 870622 x3005


F. Alfredo Rego wrote:
> At 12:08 PM +0000 3/13/03, Robert Mills wrote:
>
>> I'm looking for a better way of listing the structural differences
>> between two databases.
>>
>> Currently I'm using our database tool (FlexiBase) to generate a
>> schema for both databases and then using Allegro's SCOM utility to
>> compare the two schemas. One problem with using FlexiBase is that it
>> adds loads of comments that have to be removed before the comparison
>> is done (displays loads of incorrect differences otherwise).
>>
>> Does anybody have a better method that does not require any manual
>> editing?
>
> Adager includes, in its contributed library group, Allegro's DBHTML
> program, which generates a "lean" schema (Adager-generated schemas may
> be as verbose as Flexibase's, because I am sure we both want to be
> extra helpful -- a friendly "attitude" which, for your current
> purposes, happens to be more of a hindrance).
>
> I'll be delighted to send you a DDS tape (or to prepare an Internet
> download at Adager's site) for your convenience -- at no charge, of
> course!
>
> Here is the documentation:
>
>
>> run dbhtml.library.rego
>
> Welcome to DBHTML     (version 960721)
>
> Copyright (c) 1996  Allegro Consultants, Inc.
> Authors: Stan Sieler ([log in to unmask]) and Charlie Rand
> ([log in to unmask]).
>
> For help, type: HELP
>
> DBHTML: help
>
> (Help updated: 96/07/21)
>
> DBHTML is a utility to display the schema for an IMAGE database
> in either DBSCHEMA syntax or as an HTML file.
>
> Commands:
>
>     DO      [prefix]
>
>        If a prefix is specified, finds the more recent redo line
>        that matches the prefix and re-submits it.  If no prefix is
>        specified, the most recent input is re-submitted.
>
>     Exit
>
>        Terminates DBHTML.
>
>     Help    [command_name_prefix]
>
>        HELP <cr> displays the entire help text.
>        HELP H    displays help for all commands starting
>                  with H.
>
>     HTML  basename [filename]  [DELETE]
>
>        Generates an HTML page describing the specified database.
>        If filename is omitted, output is sent to $STDLIST.  By
>        default, if an existing file with the same output name
>        exists, the command is aborted.  The DELETE option tells
>        DBHTML that it should purge any existing file with the same
>        name.
>
>     LISTREDO
>
>        Lists the REDO stack, which persists across runs (while in
>        the same session or job).
>
>     REDO    [prefix]
>
>        If a prefix is specified, finds the more recent redo line
>        that matches the prefix and presents it for editing and
>        re-submitting.
>
>        If no prefix is specified, the most recent input is
>        presented for editing and re-submitting.
>
>        The editor used by REDO is QZMODIFY.  Pressing ^W and then
>        H will result in help information.
>
>     RESET   <DBHTML_flag>  [...]
>
>        See SET
>
>     SCHEMA basename [filename]  [DELETE]
>
>        Generates a DBSCHEMA-style output describing the specified
>        database.  If filename is omitted, output is sent to
>        $STDLIST.  By default, if an existing file with the same
>        output name exists, the command is aborted.  The DELETE
>        option tells DBHTML that it should purge any existing file
>        with the same name.
>
>     SET    <LP | PAGING>  [...]
>
>        Turns on the specified option(s) or flag(s).  The state of
>        all options/flags is reported at the end of the SET (or
>        RESET) command.  To see the options and flags without
>        changing any of them, enter: SET
>
>        SET LP routes all subsequent output to the printer instead
>        of to the terminal.  RESET LP cancels this.
>
> Syntax note: where multiple parameters are optional, commas are
> needed to indicate omission of a parameter if you want to specify
> subsequent parameters.
>
>
> -------------------------
>
>
> Cordially,
>
>    _______________
>   |               |
>   |               |
>   |            r  |  Alfredo                     [log in to unmask]
>   |          e    |                           http://www.adager.com
>   |        g      |  F. Alfredo Rego
>   |      a        |  Manager, R & D Labs
>   |    d          |  Adager Corporation
>   |  A            |  Sun Valley, Idaho 83353-3000            U.S.A.
>   |               |
>   |_______________|
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2