Re: Backup and Restore Question

SQL Question:- Awking a script to load a set of tables, most of them have reference constraints. Any one have a script to create a list of tables ordered so that referencial constraints are not violated. A simple list gives: - { load from t0250hmch_addid.unl insert into t0250hmch_addid; # 691: Missing key in referenced table for referential constraint (Loading . . . 847: Error in load file line 1. load from t0260pol_status.unl insert into t0260pol_status; . . . etc. } My initial look at this suggests and hour or two in the sys tables, but ole farther time has other desires as I am sure this will end up as a Stored Procedure. I am contracting on a site that has strict DBA and my usual trick of dropping all the constaints is not available. As a many year 4GL'er this would be a simple task, but this route is not available either. A damned SPL site, moving to Oracle as well. Will they never learn!! Mind, it keeps us contractors eating a crust or two, as all un sundry here no longer want to known Informix. Any kwiky solutions out there? Regards Ian A non metaphorical.