Re: NEED HELP W/ INFORMIX

Getting a schema is as easy as the following. dbschema -d database -t all schema.sql Replace database with the name of the database, minus the '.dbs' extension. schema.sql is the name of the file that you wish to put the schema in. all means all the tables. There is a caveat though. dbschema won't spit out any of the of the access permissions. Or, it won't spit them all out. Anyway, you won't get an exact picture of the database, indices, permissions, etc. As far as the unloading goes you will have to unload each table by hand, one at a time. Unless you can use dbexport. You will have to read up on that one on your own. I've only used it a couple of times. Good luck. George Teachman