Try OpenEdge Now
skip to main content
Basic Database Tools
Table Tasks : Binary dump and load : Performing the binary dump

Performing the binary dump

Use the following PROUTIL command to perform a binary dump:
proutil dbname -C dump tablename directory [ -index num ]
Specifies the database from which you want to dump. You must completely define the path.
Specifies the name of the table containing the data you want to dump.
Specifies the name of the target directory into which the data will be dumped.
-index num
Specifies an index with which to dump the table's contents. If you choose not to use this option, the command uses the primary index to dump the table.
Note: Additional parameters to PROUTIL DUMP are available for security (encryption) and performance.
PROUTIL DUMPSPECIFIED provides the ability to dump portions of a table based on specified selection criteria.
Note: For a complete descriptions and syntax, see OpenEdge Data Management: Database Administration.
The dump command writes the data to a dump file named, where table is the name of the table that was dumped. For example, if you dump data from the table named "customer," the procedure creates a dump file named in the directory you specify in the command.
Each binary dump file contains a header and a description for each record in the table. The dump file appears in the following format:
Record length
Table number
Binary record
Record CRC
The file header contains information that appears in the following order:
*Version number
*Date and time the file was created
*Name of the table being dumped
*Number of the table being dumped
*CRC of the table being dumped
*Number of fields in the table
*Name of the database in which the table resides
*Section number
*Number of the first record
When the dump procedure finishes, a screen message reports the number of records and the number of kilobytes of data that were dumped.