IIUG Software Repository Files

#
# NAME:     README
#           $Id: README,v 1.5 1999/07/21 19:49:20 hugo Exp $
#
# PROJECT:  tbschema
#
# LICENCE:  tbschema is distributed under the GNU Public Licence (GPL).
#           See the COPYING file for licence information.
#
#

tbschema is a tool for Informix databases. It works like dbschema from
Informix. It bases on source I found at IIUG webserver and was first written
by Albert E. Whale.

There a several reasons why I made this changes.

First under special circumstances the vendor tools gives up 
with an error message. This happens especially when you are working with
primary and foreign key definitions. You can create them, but if you 
want to have a schema you got a error message like 'duplicate value for
a unique index'.

Second if you create an index before primary and foreign key, you will not
recognize, that some indexes are doubled. To recognize this you can revert
the order of displaying indexes and foreign key creation. By next creation
of this database you will get an error message about this fact.

Third is the vendor tool prints komma instead of points as decimal point
when you are using float, money or decimal default values and your operating
system uses a german locale, like my system (SCO ODT 2.0 Unix) does even if
you set DBMONEY and/or DBFORMAT. This results in a syntax error at next 
creation.

I tested this tool with
  - Online 5.0 and SCO ODT 2.0 and german locale
  - Online 5.0 and Linux 2.033 -> 2.0.36 under iBCS2
  - SE 7.24.UC5 and Linux 2.0.36 
  - IDS 7.30 U and Linux 2.0.36 and 2.2.10.
The test database does not use all features of Informix, so the tests
will not cover all of them. Check the schema output for reliability before
you use tbschema as an archive tool.

To install just type:

	./configure; make

This will generate the binary tbschema. tbschema has some command line 
parameter. Type tbschema -? to have a look.
With the parameter ´-e´ tbschema will create a subdirectory named 
<database>.exp and unload all tables to this directory.
The name of the unload file is <table name>.unl. The scheme of the database 
is written to the file <database>.sql. You can use this file to re-import 
the database just by running this script inside dbaccess.
The vendor program dbimport won't work with this command file.

This program isn't perfect and needs a lot of changes (see TO-DO). I hope 
somebody will find this program useful. For bugs or new features send
email to mg@giant.north.de

Thanks
  mg