IBM 000-8697 Manuale Utente

IBM Informix OnLine Database Server Administrator’s Guide

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

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 I

nformix

SE

database server, or vice versa.

Syntax for the

SE

 database server dbimport utility differs from OnLine

syntax. Refer to the

uide for more details

about dbimport 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.

instructs dbexport to complete exporting unless fatal errors
occur.

suppresses display (to the standard output) of error messages,
warnings, and generated

SQL

 data definition statements.

specifies the name of the database you want to export.

-c

-q

dbexport

Destination

Options

p.

-d