Referential Integrity Rules analyzing routine

Dear Collegues, I coded utility which seems to me helpful in DBA and Project Leader every day work. Sources take approx. 34K, including 13K of the INFORMIX 4GL code and 20K of manuals. I would be glad to send you this, if needed. Take care. Pavel (pvl@cso.spb.su) ---------------------------------------------------------------- dbref (INFORMIX DBA) dbref (INFORMIX DBA) File: @(#)dbref.man 1.1 3/30/95 Synopsis: dbref [ dbname ] dbname is a database name; if omitted, DBNAME enviromental variable is assumed. Description: DBREF (DataBase REFerences analyzer) analyzes the Referential Integrity Rules. It gets them from "informix".sysreferences and "informix".sysconstraints Informix System catalog tables. Then it tries to order the Referential Integrity Tree. If attempt successed, DBREF generates two INFORMIX SQL scripts: LoadDB.sql - database loading script according to proper order, and UnloadDB.sql - database unloading script ( for symmetry ). If attempt failed, DBREF creates LoadDB.err file which contains list of tables which cause Referential hierarchy problems. Compatibility: DBREF utility was tested on the following equipment: Computer Model: IBM PS/2 Model 95A Operation System: SCO ODT UNIX, release 3.0.0 Filesystems: AFS, EAFS Informix Server: Informix On-Line v.5.01 Database Log Mode: ANSI Files: LoadDB.sql - Database Loading INFORMIX SQL Script UloadDB.sql - Database Unloading INFORMIX SQL Script LoadDB.err - List of tables caused Referential Tree problem See also: dbexport (INFORMIX), dbimport (INFORMIX), dbload (INFORMIX) ---------------------------------------------------------------------------