contact contact

dbimport utility

» Usage | Notes | Examples | See also
  The dbimport utility may be used to import (text based) export files in a database.


usage: dbimport [options] database [set ...]
 -help   - show usage (this list)
 -u user - set user name
 -p pswd - set password
 -c cnt  - records per transaction
 -i path - set import path
 -v      - verbose output
 -t      - trace item value assignment
 -r file - restructure database, '-' = no file
 -s file - import from single file, '-' = stdin
 -e file - log errors instead of aborting
 -f sep  - field separator, default is ','
 -z cset - set import code set (roman8, iso88591)
 -d flgs - debug flags
 -x      - exclude specified data sets
 -T      - TurboIMAGE compatibility
 -Z      - uncompress import file 
Database specifies the database name (and/or address). A list of data set names or numbers may be specified. If present, only the listed data sets are processed.

The options are:

The -help option displays a brief help text.

-u user
The -u option specifies the database user (or a file holding the database user and/or password). Defaults to the public user unless a default user is specified with the EQ_DBUSER environment variable.

-p password
The -p option may be used to specify the password for the database user (or a file holding the password). If not specified, the password is obtained using the EQ_DBUSER and/or EQ_DBPASSWORD environment variables.

-i path
The -i option specifies the directory that holds the export files. By default, export files are expected in the current directory. This option has no effect if the option -s is used.

The -v option outputs progress information (to stderr).

-s file
If the -s option is present, dbimport will read the export data from the specified file rather than using a separate export file per data set. If a - is used as a file name stdin is used.

-e file
If the -e option is present, dbimport will log error messages to the specified file instead of aborting. By default dbimport will terminate with an error if a records cannot be imported.

-f sep
The -f option may be used to specify a different field separator. By default a comma is used to separate files in an export file.

-z cset
The -z option may be used to specify the character set of the import file. By default, the import file is expected to use the platform default character set. If different, any string data data is transformed as necessary during dbimport. Supported character sets include iso88591 and roman8.

The -x option specifies that any set in the set list is excluded.

-c cnt
The -c option may be used to specify the number of records per transaction. The default is 100 (as of B.08.20).

-r file
If the -r option is specified, dbimport will operate in restructure mode. In this mode, data sets and items are identified by name rather than number or position in record and data types are converted as necessary.
A file name "-" indicates to use the restructure defaults (-r-). Otherwise, a file holding a restructuring specification may be specified (-r file).

The option -t may be used in restructure mode to verify the restructure field assignment.

The -T option specifies the TurboIMAGE compatibility mode. This has the effect that item types embedded in the export file are understood as TurboIMAGE compatible. This is (only) useful if the Eloquence dbexport utility on MPE is used with the -r option and the schema files differ and dbimport is run with the -r option.

-d flags
The -d option specifies debug flags and is normally not used.

If the -Z option is present, compressed input files *.exp.gz are used. By default, compressed / un-compressed input files are detected automatically.


  • dbimport places a set lock on the data set currently imported.


$ dbimport -vs sample.exp sample
Database            : sample
Import file         : sample.exp
Records/Transaction : 100

DATA SET               COUNT
---------------- --- - --------
CUSTOMERS        001 M     1183
PARTS            002 M      182
ORDERS           004 D       47
LINEITEMS        005 D      136

See also

dbexport utility
dbimport database restructuring

  Privacy | Webmaster | Terms of use | Impressum Revision: 2018-12-05  
  Copyright © 1995-2021 Marxmeier Software AG