Re: How do I find dbschema?
Posted in 1994
holly_gordon@tsl.texas.gov ("Holly Gordon") writes:
>This is really basic, I'm sure, so please forgive me...
>I am trying to generate the schema for a database. Typed:
>dbschema -d dbname rose -o sch.list
^^^^^^ don't type this, substitute database name for it
thus:
dbschema -d rose -o sch.list
Note: some versions of dbschema don't want or need the -o options; if
it still fails try:
dbschema -d rose sch.list
================
Dennis J. Pimple
Informix CSE / Denver
303-850-0210
>This should generate the schema for a database we created in SQL that we called rose, and put the schema into a file called sch.list.
>When I try this, I get the message "could not open file rose" so does Informix rename the database? When I run a find, I can't locate "rose" anywhere.
>Many Thanks!
>-----------------------------------------------------------------------------
>Holly Gordon (hgordon@tsl.texas.gov) | SW--CLSI LIBS100+, Informix Online 4.10
>Texas State Library | OS--UNIX system V, release 3.2.0 i386
>Austin, Texas | HW--Sequent S27 (386)