DBSCHEMA Error in Syntax.

FORWARD TO: David Coburn, coburn@informix.com David, It seems to me that I need to stand corrected in my suggestion on using dbschema to print multiple tables into a single sql text file. I had thought that we could write the fillowing: dbschema -d database name -t tablename1, tablename2, tablename5 > schema.sql By your response to my original message I would have to perform dbschema 3 times to accomplish the above statement with a "Unix Cat >> command" in each dbschema run. If this is true, I stand corrected on my error, thanks for the info. I also, do not know what the originator of the question needed to perform, I assumed (nasty, nasty thing to do) he needed the schema to modify existing tables. I don't know. It would have helped to have had more info. By the way, its good to know that we have an Informix Engineer with us. Michael S. Gordon ADP Administrator Avionics Division * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Michael Gordon Sacramento Army Depot * * ADP Administrator Directorate For Maintenance * * E-Mail: maint72@saad-emh1.army.mil Attn: SDSSA-MPA 430 * * DSN: 839-4044 Michael S. Gordon * * Comm.: (916) 388-4044 Sacramento, CA 96813-5036 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *