Syntax of the dbexport Command

Home | Previous Page | Next Page Data Migration Utilities > The dbexport and dbimport Utilities >

Syntax of the dbexport Command

>>-dbexport----------------------------------------------------->
 
     .----------------------------------.
     V                                  |
>--+---+------------------------------+-+--database-+----------><
   |   +- -c--------------------------+             |
   |   +- -d--------------------------+             |
   |   +- -q--------------------------+             |
   |   |                         (1)  |             |
   |   +-| Destination Options |------+             |
   |   +- -ss-------------------------+             |
   |   '- -X--------------------------'             |
   '- -V--------------------------------------------'

Notes:

See page Destination Options

Element	Purpose	Key Considerations
-c	Makes dbexport complete exporting unless a fatal error occurs	References: For details on this option, see Errors.
-d	Makes dbexport export simple-large-object descriptors only, not simple-large-object data	References: For information about simple-large-object descriptors, see the IBM Informix: Optical Subsystem Guide. Restrictions: Not supported by SE.
-q	Suppresses the display of error messages, warnings, and generated SQL data-definition statements	None.
-ss	Generates database server-specific information for all tables in the specified database	References: For details on this option, see Server-Specific Information.
-X	Recognizes HEX binary data in character fields	None.
-V	Displays product version information	None.
database	Specifies the name of the database that you want to export	Additional Information: If your locale is set to use multibyte characters, you can use multibyte characters for the database name. References: If you want to use more than the simple name of the database, refer to the Database Name section of the IBM Informix: Guide to SQL Syntax.

You must have DBA privileges or log in as user informix to export a database.

Global Language Support

When the environment variables are set correctly, as described in the IBM Informix: GLS User's Guide, dbexport can handle foreign characters in data and export the data from GLS databases. For more information, refer to Database Renaming.

End of Global Language Support

You can use delimited identifiers with the dbexport utility. The utility detects database objects that are keywords, mixed case, or have special characters and places double quotes around them.

In addition to the data files and the schema file, dbexport creates a file of messages named dbexport.out in the current directory. This file contains error messages, warnings, and a display of the SQL data definition statements that it generates. The same material is also written to the standard output unless you specify the -q option.

During the export, the database is locked in exclusive mode. If dbexport cannot obtain an exclusive lock, it displays a diagnostic message and exits.

Tip:

The dbexport utility can create files larger than 2 GB. To support such large files, make sure your operating system file-size limits are set sufficiently high. For example, on UNIX, set ulimit to unlimited.