IIUG Software Repository Files

Should be really called 'Gotchas'

Definitely Alpha code but is in production on a couple of
sites

Tested with
===========

Informix      7.24/7.30/7.31/9.14/9.20 (Limited extended type support)
Compiled      6.20/7.31 4gl, ESQL 2.41/2.50
C Compilers   gcc-2.95.2, SUNWcpro, AIX std compiler
Solaris       2.6/7 on Sun E450,E1000,10,20
AIX           S70
Linux         RH6.2
Web Servers   Apache 1.3.12 (with/without mod_ssl), 1.3.14
              Netscape-Enterprise/3.6 SP1 
Perl          5.6.0

Installation
============

Run the install script

Apply whatever Web based security restrictions are required.  The minimum
is probably configuring directory level security for the directory
containing dbweb.pl

General Stuff
=============

When an Informix instance is selected then a username/password
will be requested.  If the instance is changed then dbweb will 
try to use the same username/password combination, if this fails
then a new username/password will be requested.  Only the current
instance username/password are maintained.

Directory Structure
===================

DBW_BINPATH:  Where the dbweb binary is located
DBW_TMP:      The directory to be used for local temporary storage
DBW_HTMLROOT: The path form the Web site root 
CGIPATH:      The cgi-bin for the website
DBW_HOME:     The home of dbwebd, the area that the PID file is located
			  and a temporary area for holding of local output files
			  from the requested command

Formatting
==========

The html pages can be formatted as either fixed width or as a percentage
of the current window depending on the setting of TABWIDTHFIXED (html.h).
The variable TABWIDTH then specifies the table width, for fixed width
formats this is in pixels, for non fixed width it is the percentage
of the current screen.

By default all the SQL column types are returned in uppercase, including
the named types.  This is controlled via DBW_COLUPPER (coltype.ec).

When the output is formatted, particularly stored procedures, triggers,
and views, then <tabs> are translated into html spaces.  By default this
is 8 per tab and is controlled via DBW_INDENT (dbweb.h)



Things to note
==============

1	The password files are kept in clear.

2	The dbweb.pl file must in the cgi-bin directory.

3   If the Informix environment is not set when the web
	server is started then the dbweb.pl script should be 
	altered.  

	INFORMIXSERVER
	INFORMIXDIR
	LD_LIBRARY_PATH

4   There are two debug options, one just tracks function usage (DEBUG), 
	the other tracks the html calls (HTMLDBB), both are located
	in dbweb.h