Re: DBEXPORT/DBIMPORT to move tables to anothe

In article 0009067F@databank.com, ldeckard@databank.com (L Deckard) writes: >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. Use the following command: $ dbimport <database-name> -d <dbspace-name> [-l (if logging)] This should work fine. ------------------------------------------------------------------------------- . . | ... ... | John M. Shoemaker internet: shoe@forte.sps.mot.com ..... ..... | Senior Software Engineer voice: (602) 244-6074 fax: 5898 .. ... .. | Business Integration Group pager: (602) 219-1679 . . . | Semiconductor Products Sector | 5005 E McDowell Road Motorola-SPS | Phoenix, AZ 85008 ------------------------------------------------------------------------------- EXEC SQL include "disclaimer.h" -------------------------------------------------------------------------------