A common file format is used by the hp260exp, dbexport
and dbimport utility programs.
All data (fields) are saved as a text. This makes it possible to
use a text editor (such as vi) or common UNIX tools like
cut, grep or sed to evaluate or operate on the data.
Single File format
dbexport and dbimport are able to process a "single file format"
(specified by the -s command line option)
which can hold data for multiple data set. In addition to the data,
control lines starting with a hash sign (#) are included in the
# DATABASE = <Database name>
# SET <Set number> = <Set name>
This information is used by dbimport to recognize the different
Please Note: Data sets must be provided in ascending order (depending
on the data set number, data set names are not used unless restructure
# DATABASE = SAD
# SET 03 = PRODUCT
# SET 04 = LOCATION
Additional restructure information
In addition to data and separation information, dbexport could also
include information on the database structure. This can be used by
dbimport to restructure the database depending on field names rather
than field position.
Control lines start with a hash sign (#).
# SET <Set Number> = <Set Name>
# <Item Index> <Item Name> <Item Typ>
# SET 06 = CUSTOMER
# 1 ORDER-NO X10
# 2 NAME X30
# 3 ADDRESS 2 X30
# 5 CITY X16
# 6 STATE X6
# 7 COUNTRY X12
# 8 ZIP-CODE X8
# 9 ORDER-DATE I
# 10 SHIP-DATE I
# 11 REGION X6
# 12 PRODUCT-NO I
# 13 PRICE L
# 14 SALESPERSON X4