Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Andy Wilson — — source: Informix-list mailing list archive (1991-1998)
In article <ldeckard.33.0009067F@databank.com>, ldeckard@databank.com says...
>
>I have a 100 tables defined in a database in ROOTDBS. I would like to DBEXPORT
>the database and DBIMPORT all the tables back into the same database name, but
>in *another* DBSPACE name. What is required to do this? Is there a parameter in
>the DBIMPORT command or do I need to edit and change the *.sql file that is
>created by the DBEXPORT command?? Thanks! Lenny.
You guessed right, edit the sql file and change the create database statement to "create
database in dbspace ..."
You'll need to check the exact syntax 'cos I haven't got a manual handy, and I've got
the memory of one of those little slimy aquatic things ...
--
+==============+=======================+======================+==========+
| Andy Wilson | Mountfield Software | St Leonards-On-Sea | England |
+--------------+-----------------------+----------------------+----------+
| andyw@mountfield.co.uk | Compuserve 73171,3627 |
+======================================+=================================+
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.