Re: DBSCHEMA not working.
Michael,
I don't know what they were doing, but that syntax works fine on the Sun,
SCO and DOS machines that I have access too. Perhaps they specified
multiple table names? As dbschema works, if they typed in
dbschema -d dbname -t tab1 tab2 > filename
what would be recorded in filename would be the dbschema banner. A file
called 'tab2' would be created with the sql syntax for tab1.
What would have been correct would be the following:
dbschema -d dbname -t tab1 filename1
dbschema -d dbname -t tab2 filename2
cat filename2 >> filename1
As it stands, the table specification is either one or all, not multiple
table names.
David Coburn coburn@informix.com
Systems Engineer ...!uunet!infmx!coburn
Informix Software, Inc.
============================================================================
The stuff contained herein is not necessarily the opinion of my employer.
============================================================================
>
> Message from Michigan State University
>
> DBSCHEMA not working because of system error.
>
> Try using: dbschema -d database name -t table name > filename <return>
>
> where database name is the formal database named,
> and table name is the name(s) of specific tables,
> ttable name all for all tables.
>
> > filename direct output to a text file.
>
>
>
> 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 *
> * *
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>
>