Release 10.1A: OpenEdge Development:
Basic Database Tools

> ## Loading table contents

> The Data Dictionary 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.

> #### Notes

> - Table definitions must be in the database before you can load table contents.

> - You must load your sequence values separately.

> There are two ways to load the table contents:

> - Use the Data Dictionary tool.

> - Use the Bulk Loader (PROUTIL BULKLOAD) utility. For information on using the Bulk Loader, see the chapter on administration utilities in the OpenEdge Data Management: Database Administration .

> | To load table contents into a database:

> 1. Make sure that the working database is the target database where you want to load the table contents.

> 2. Choose Admin Load Data and Definitions Table Contents (.d files) from the menu bar. The Data Dictionary alphabetically lists all the tables defined for your database.

> 3. 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.

> The Data Dictionary 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.

> 4. 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, the Data Dictionary loads the files from the current directory. The Data Dictionary loads each table from the corresponding `table-dumpname`.`d` filename.

> The Data Dictionary also prompts you for an acceptable error rate.

> 5. Specify the error rate.

> As the Data Dictionary 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. The Data Dictionary 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, The Data Dictionary must successfully load 90 records from every set of 100 records loaded.

> 6. Select Output Errors to Screen to view error messages generated while loading table data. The default output for errors is to a file.

> 7. Choose OK. After loading the table contents, the Data Dictionary displays a status message and prompts you to continue.

> 8. Choose OK to return to the Data Dictionary main window.

> | To load user table contents:

> 1. Choose Admin Load Data and Definitions User Table Contents. The Data prompts you for the file from which you want to read the user file contents. The default filename is `_user.d`.

> 2. Specify the filename or accept the default. After loading the user file contents to the specified file, the Data Dictionary displays a status message and prompts you to continue.

> 3. Choose OK to return to the Data Dictionary main window.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095