15 March 1996               SDRTool           Jeffrey R. (Sydd) Souza

    System Discrepancy Report Creation/Maintenance/Tracking Tool

The following is pretty much the sum total of documentation I have on
installation & setup of the SDRTool.  The tool's been in use at GTE 
over 3 years now, and has been used on may projects on many platforms.

Compatibility
-------------

It currently supports both RCS and SCCS (this is all in the scripts)
for its maintenance of the files which contain the bulk of the
information on a given SDR.
We currently use it with Sybase & Informix for databases (and I've
researched but have not had the time to complete my mods for the
Oracle version - soon).

It's written in ANSI C and OSF/Motif UIL.  It has been tested on
SunOS, PC Linux, HPUX and Dec Ultrix using OSF/Motif 1.2 and 2.0
with X11R5 and X11R6 but will probably port easily to any ANSI C
UNIX platform with X11R4 or above and OSF/Motif 1.1 or above.  In
other words there's nothing fancy here.

Database Requirements
---------------------
  Sybase, Informix and Oracle all supply a command line interface
to the database along with their C library and fancier graphical
interfaces.  They are isql, dbaccess & sqlplus respectively, and
they usually provide "accounts" much like UNIX user accounts
(though there's no direct correlation).  I use three SQL commands
only, in the following generic form (though each DB uses a
slightly different syntax):

Get a Record:
   select field1,field2 from tablename where field1 = "blah"
Insert a New Record:
   insert into tablename (field1,field2) values ("blah","yadayadayada")
Update a Record:
   update tablename set field1="blah",field2="yada yada" where field1 = "blah"

The tool literally places the commands in a file then invokes the
command line interface for tha DB and parses the output from the file
in which it was caught.  This allows it to not have to deal with
libraries and direct C calls.  Though it's slower, this method provides
a bit more flexibility in my opinion.

Installation
------------

Well I currently have it in a gzipped tarfile (fits on a low density
3-1/2" floppy!) but if you're reading this you've already figured that
out and extracted everything.  Sorry about the mess - I'll cleanup
one day, but for now you should be prepared to have to change the
makefile and you'll probably need your Database Administrator (DBA)
to get involved, at least to help you decide where the database will
reside physically in DB partition spaces.

There is a config subdirectory containing a bunch of text files
called adding_project*.txt.  Peruse them and follow the directions.
The step 2 file is actually several, one for each database.  The
2s is for Sybase, 2i for Informix and 2o (eventually) for Oracle.
I also envision a 2g for GNU dbm configuration instructions.

You'll probably have to tweak the makefile as well.  I used gcc
on Linux, clcc (CenterLine's compiler) on SunOS and whetever HP &
DEC had, and they were all called "cc" and had different switches.
Also, where X Window and Motif were installed varied with the
haircuts of the sysadmin types who installed them.

There's a lib subdirectory which contains the libutilities.a library
makefile & sources, along with the generi*.h includes called for
by some of the sdr*.h files.  The main makefile should make this
library, but if not, go there & make it.  The executable won't
link without it.  Make sure there are -Ilib & -Llib switches in
the main makefile so the code can find the generi*.h include files
and ultimately the libutilities.a library.