7-6 IBM Informix OnLine Database Server Administrator’s Guide
Syntax
TheSQL statements contained in the dbexport schema file do not contain all
available information. The following information is omitted:
■Initial and next extent values
■Lock mode
■Dbspace where the table should reside
■Blobspace where a blob column should reside
■Logging mode of the database, if there is one
Forthis reason, you might want to unload the file to disk where you can edit
itbefore you import the database. Refer to page 7-9 for more details about the
contents of the schema file.
You can use thedbexport/dbimport pair to convert databases from an
OnLinedatabase server to an IBM Informix SE database server, or vice versa.
Syntax for the SE database serverdbimport utility differs from OnLine
syntax. Refer to the IBMInformix SE Administrator ’sGuide for more details
aboutdbimport syntax.
Syntax
The dbexport utility creates a file of messages calleddbexport.out. This file
contains error messages and warnings, and it also contains a display of the
SQL data definition statements it is generating. The same material is also
written to the standard output unless you specify the-q option.
-c instructsdbexport to complete exporting unless fatal errors
occur.
-q suppressesdisplay (to the standard output) of error messages,
warnings, and generated SQL data definition statements.
database specifies the name of the database you want to export.
-c -q
dbexport database
Destination
Options
p. 7-7
-d