Filter
Top Products
7-6 IBM Informix OnLine Database Server Administrator’s Guide
Syntax
The SQL 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
For this reason, you might want to unload the file to disk where you can edit
it before you import the database. Refer to page 7-9 for more details about the
contents of the schema file.
You can use the dbexport/dbimport pair to convert databases from an
OnLine database server to an IBM Informix SE database server, or vice versa.
Syntax for the SE database server dbimport utility differs from OnLine
syntax. Refer to the IBM Informix SE Administrator’s Guide for more details
about dbimport syntax.
Syntax
The dbexport utility creates a file of messages called dbexport.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 instructs dbexport to complete exporting unless fatal errors
occur.
-q suppresses display (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