Usage

usage: dbexport [options] database [set ...]
options:
 -help   - show usage (this list)
 -u user - set user name
 -p pswd - set password
 -o path - set output directory (not single file)
 -v      - verbose output
 -c      - chained export
 -a      - export automatic data sets
 -r      - create restructure information
 -s file - output into single file, '-' = stdout
 -f sep  - field separator, default is ','
 -z cset - set export code set (roman8, iso88591)
 -w wdth - specify dset id width (default 3)
 -d flgs - debug flags
 -m mode - open database in specified mode
 -x      - exclude specified data sets
 -Z      - compress export file 

The options are:

-help

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.

-o path

The -o option specifies the directory where export files are created. By default, export files are created in the current directory. This option has no effect if the option -s is used.

-v

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

-c

If the -c option is specified, the data is exported in chained order (for the primary chain). By default the data is exported in sequential order.

-a

If the -a option is specified, automatic masters are also exported. By default automatic masters are not exported.

-r

The -r option causes dbexport to output additional information in the export file on the data set structure (item names and types). This may be used subsequently by dbimport if the database structure of the source and target database is different.

-s file

If the -s option is present, dbexport will output the export data to the specified file rather than using a separate export file per data set. If a - is used as a file name stdout is used.

-f sep

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

-z cset

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

-w width

The -w option may be used to specify the number of digits used for the data set number in the name or the export file. Only useful for backwards compatibility with historic Eloquence versions. The default is 3.

-d flags

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

-m mode

Open the database in specified mode. By default, the database is opened in mode 9 (read-only shared).

-x

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

-Z

If the -Z option is present, compressed output files *.exp.gz are created.

Notes

• Please note that dbexport does not place a lock on the database.

• When using chained export (option -c) the master set for the primary path is read sequentially and any records for the detail set are exported for this chain head.

• Packed and Zoned items are verified during export. A zero value is assumed for an invalid/corrupted item value and a warning message is printed if a set has corrupted Z/P item values.

• For large databases bulk export/import using dbbexp and dbctl bimport should be considered as an alternative.

Examples

$ dbexport -vc sample
Database        : sample
Export path     : .

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

dbexport -s- sample | md5sum

See also