Re: dbexport

Steve Romankiw <sromankiw@execrisk.com> wrote in article <5fhonp$s2p@cssun.mathcs.emory.edu>... > I am using dbexport to get unload data from one database and loading > into another. I noticed that in the *.sql that the dbspace locations > have been omitted. Since we have tables spread across various dbspaces > (non-fragmented tables), it is important to maintain this information in > the *.sql file. To run dbexport, I used the following commands: > dbexport -d <db> -c <dir> -ss -q. I was hoping the -ss would be give me> database specific information. "-ss" should do the trick. The only tables that won't have a dbspace specified on the create statement are those which reside in the default dbspace of the database. HTH Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com