3 Eloquence Migration Tools

hp260exp

The Eloquence hp260exp command performs a serial or chained read on all data set files or the selected data sets of the given HP 260 database, extracts the data, and generates export text files labelled databasename.datasetnumber.exp. Automatic master data sets are excluded. In addition, it generates a schema text (.txt) file.

NOTE: Any existing maintenance password in the HP 260 database will not be taken over and must be re-installed in the new database with the dbmods program.

Syntax

hp260exp [options] root file [set ...]

Options:

-o path
Set output path.
-c
Chained export.
-s
No schema text file (only sets).
-v
Verbose.
NOTE: If no data set name or number is given all data sets belonging to the named database will be exported.

Examples:

To export all data sets from the SAD database, enter the following command:

hp260exp -v -o./export SAD

The output from this command is written to the subdirectory export. This is specified by the -o./export option. The period (.) before /export represents the current directory.

In addition to export files, this command generates a schema text file and root file for the SAD database.

Display: 

B1368A HP260EXP (C) COPYRIGHT HEWLETT-PACKARD GmbH 1991 (A.03.00)

Processing data base SAD
Root file path:
-o path = set output path

DATA SET              CAPACITY #ENTRIES
---------------- -- - -------- --------
DATE             01 A       51        1
ORDER            02 A      101      100
PRODUCT          03 M       11        8
LOCATION         04 M       17       10
OPTION           05 D      300       16
CUSTOMER         06 D      100       11
  |              |  |        |        |
Data set name    |  |        |    Number of entries
                 |  |        |
                 |  |        |
                 |  |     Possible number of entries
                 |  |
                 |  |
                 | Data set type 
                 | A = automatic
                 | M = manual master
                 | D = detail
                 |
               Data set number
To verify that the export files, schema text file, and root file have been created, use the HP-UX ll (long list) command. For example, the following command displays the export files: 


  ls -l *exp

-rw-rw-rw-   1 guest   migctr     105 Aug 14 21:12 SAD.03.exp
-rw-rw-rw-   1 guest   migctr       9 Aug 14 21:12 SAD.04.exp
-rw-rw-rw-   1 guest   migctr     324 Aug 14 21:12 SAD.05.exp
-rw-rw-rw-   1 guest   migctr     698 Aug 14 21:12 SAD.06.exp
HP260 to Eloquence Migration - 13 FEB 2003