Syntax of the dbimport Command

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

Syntax of the dbimport Command

>>-dbimport----------------------------------------------------->
 
     .---------.
     V         |                          (1)                      (2)
>--+---+-----+-+--| Input-File Location |-------| Create Options |-------database-+-><
   |   +- -c-+                                                                    |
   |   +- -q-+                                                                    |
   |   '- -X-'                                                                    |
   '- -V--------------------------------------------------------------------------'

Notes:

See page Input-File Location Options
See page Create Options

Element	Purpose	Key Considerations
-c	Instructs dbimport to complete importing even though it encounters certain nonfatal errors	References: For more information, see Errors and Warnings.
-q	Suppresses the display of error messages, warnings, and generated SQL data-definition statements	None.
-V	Displays product version information	None.
-X	Recognizes HEX binary data in character fields	None.
database	Specifies the name of the database to create	Additional Information: To use more than the simple name of the database, see the Database Names segment in the IBM Informix: Guide to SQL Syntax.

The dbimport utility can use files from the following location options:

All input files are located on disk.
All input files are located on tape.
The schema file is located on disk, and the data files are on tape.

Important:

Do not put comments into your input file. Comments might cause unpredictable results when the dbimport utility reads them.

The dbimport utility supports the following tasks for a new Informix database server (excluding SE):

Create an ANSI-compliant database (includes unbuffered logging)
Establish transaction logging for a database (unbuffered or buffered logging)
Specify the dbspace where the database will reside

The user who runs dbimport is granted the DBA privilege on the newly created database. The dbimport process locks each table as it is being loaded and unlocks the table when the loading is complete.

Global Language Support

When the GLS environment variables are set correctly, as the IBM Informix: GLS User's Guide describes, dbimport can import data into database versions that support GLS.

End of Global Language Support