Download Latest Version tpc-c-ifmx.tar.gz (392.7 kB)
Email in envelope

Get an email when there's a new version of IIUG Software Repository

Name Modified Size InfoDownloads / Week
Parent folder
alias.c 2019-06-13 1.2 kB
alias.h 2019-06-13 116 Bytes
alias_info.c 2019-06-13 3.8 kB
alias_info.h 2019-06-13 910 Bytes
cast.c 2019-06-13 914 Bytes
cast.h 2019-06-13 122 Bytes
collection.c 2019-06-13 1.5 kB
collection.h 2019-06-13 103 Bytes
coltype.ec 2019-06-13 11.9 kB
coltype.h 2019-06-13 1.5 kB
column.c 2019-06-13 2.5 kB
column.h 2019-06-13 290 Bytes
condition.c 2019-06-13 3.2 kB
condition.h 2019-06-13 147 Bytes
config.h.in 2019-06-13 7.7 kB
database.c 2019-06-13 562 Bytes
database.h 2019-06-13 72 Bytes
datatype.c 2019-06-13 6.8 kB
datatype.h 2019-06-13 416 Bytes
dbchunks.ec 2019-06-13 6.7 kB
dbcom.c 2019-06-13 2.2 kB
dbcon.c 2019-06-13 3.8 kB
dbconnect.ec 2019-06-13 3.2 kB
dberr.ec 2019-06-13 2.9 kB
dbformat.c 2019-06-13 300 Bytes
dbidx.ec 2019-06-13 7.1 kB
dbinfo.ec 2019-06-13 30.0 kB
dbio.c 2019-06-13 3.7 kB
dbmain.c 2019-06-13 8.4 kB
dbmonitor.ec 2019-06-13 7.1 kB
dbperms.ec 2019-06-13 10.1 kB
dbref.ec 2019-06-13 9.7 kB
dbserver.ec 2019-06-13 5.0 kB
dbspace.c 2019-06-13 919 Bytes
dbspace.h 2019-06-13 124 Bytes
dbuser.c 2019-06-13 1.3 kB
dbutil.c 2019-06-13 3.9 kB
dbutil.h 2019-06-13 283 Bytes
dbweb.eh 2019-06-13 921 Bytes
dbweb.h 2019-06-13 6.5 kB
dbweb_hooks.c 2019-06-13 3.2 kB
dbweb_hooks.h 2019-06-13 112 Bytes
dbwebd.c 2019-06-13 6.2 kB
dbwebd.h 2019-06-13 615 Bytes
delete.c 2019-06-13 325 Bytes
delete.h 2019-06-13 62 Bytes
directives.c 2019-06-13 3.8 kB
directives.h 2019-06-13 227 Bytes
drop.c 2019-06-13 3.3 kB
drop.h 2019-06-13 331 Bytes
esqlc.c 2019-06-13 444 Bytes
esqlc.h 2019-06-13 62 Bytes
esqlc.mk 2019-06-13 2.0 kB
expression.c 2019-06-13 13.0 kB
expression.h 2019-06-13 704 Bytes
for_ro_upd.c 2019-06-13 496 Bytes
for_ro_upd.h 2019-06-13 97 Bytes
fragment.c 2019-06-13 3.4 kB
fragment.h 2019-06-13 260 Bytes
from.c 2019-06-13 245 Bytes
from.h 2019-06-13 63 Bytes
grant.c 2019-06-13 3.9 kB
grant.h 2019-06-13 268 Bytes
having.c 2019-06-13 249 Bytes
having.h 2019-06-13 69 Bytes
html.c 2019-06-13 25.0 kB
html.h 2019-06-13 170 Bytes
identifier.c 2019-06-13 1.7 kB
identifier.h 2019-06-13 155 Bytes
index.c 2019-06-13 2.8 kB
index.h 2019-06-13 291 Bytes
insert.c 2019-06-13 1.6 kB
insert.h 2019-06-13 132 Bytes
literal.c 2019-06-13 3.0 kB
literal.h 2019-06-13 218 Bytes
Makefile.in 2019-06-13 10.5 kB
opaque.c 2019-06-13 1.1 kB
opaque.h 2019-06-13 107 Bytes
order.c 2019-06-13 737 Bytes
order.h 2019-06-13 102 Bytes
owner.c 2019-06-13 209 Bytes
owner.h 2019-06-13 61 Bytes
routine.c 2019-06-13 5.2 kB
routine.h 2019-06-13 407 Bytes
row.c 2019-06-13 633 Bytes
row.h 2019-06-13 64 Bytes
select.c 2019-06-13 3.1 kB
select.h 2019-06-13 325 Bytes
set.c 2019-06-13 3.7 kB
set.h 2019-06-13 454 Bytes
spl.c 2019-06-13 13.8 kB
spl.h 2019-06-13 896 Bytes
sql.c 2019-06-13 1.0 kB
sql.h 2019-06-13 52 Bytes
strutil.c 2019-06-13 2.1 kB
strutil.h 2019-06-13 256 Bytes
sysinfo.ec 2019-06-13 1.8 kB
sysinfo.h 2019-06-13 194 Bytes
tabinfo.c 2019-06-13 8.7 kB
tabinfo.h 2019-06-13 1.0 kB
table.c 2019-06-13 14.1 kB
table.h 2019-06-13 1.0 kB
token.c 2019-06-13 10.0 kB
token.h 2019-06-13 1.7 kB
transaction.c 2019-06-13 495 Bytes
transaction.h 2019-06-13 114 Bytes
trigger.c 2019-06-13 4.4 kB
trigger.h 2019-06-13 350 Bytes
update.c 2019-06-13 2.1 kB
update.h 2019-06-13 192 Bytes
updstats.c 2019-06-13 1.2 kB
updstats.h 2019-06-13 75 Bytes
view.c 2019-06-13 874 Bytes
view.h 2019-06-13 64 Bytes
where.c 2019-06-13 244 Bytes
where.h 2019-06-13 67 Bytes
Totals: 116 Items   330.2 kB 0
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




Source: README, updated 2019-06-13