Progress
Basic Database
Tools
Loading Table Contents
Progress uses a contents file that you specify to load table data into your database. A contents file contains all the data for a table.
For information about performing a binary dump and load, see the “Binary Dump and Load” section later in this chapter.
NOTES
There are two ways to load the table contents:
To load table contents into a database, follow these steps:
- Access the Data Dictionary tool.
- Make sure that the working database is the target database where you want to load the table contents.
- Choose Admin
Load Data and Definitions
Table Contents (.d files) from the menu bar. Progress alphabetically lists all the tables defined for your database.
- Select the table names whose contents you want to load. Use the Select Some and Deselect Some buttons to select or deselect groups of tables.
Progress prompts you for the name of the contents file—or if you choose multiple files, the directory that contains the contents files—you want to load into your current database.
- Specify the directory name, filename, or use the default value.
When you load the contents of more than one table, enter a directory from which you want to load the contents files. If you do not specify a directory, Progress loads the files from the current directory. Progress loads each table from the corresponding table-dumpname
.d
filename.Progress also prompts you for an acceptable error rate.
- Specify the error rate. As Progress loads records from any files you designate, it might encounter data that cannot be loaded. For example, a record might have data in one of its fields that is too long for that field’s defined format. Progress does not load the record. It places all erroneous records in a table
.e
file (the name of the table with a .e extension). If you specify an error rate of 10 percent, Progress must successfully load 90 records from every set of 100 records loaded.- Choose OK. After loading the table contents, Progress displays a status message and prompts you to continue.
- Choose OK to return to the Data Dictionary main window.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |