Progress
Basic Database
Tools


Admin>Load Data and Definitions

Choose this option to load table definitions for specified tables or for all the tables in the database.

NOTE: When a menu option prompts you for a filename only, you can specify a complete pathname.

Table 10–3 describes the menu that appears when you choose this option. More detailed descriptions of the options follow the table.

Table 10–3: Load Data and Definitions Menu 
Load Data and Definitions

Data Definitions (.df file)...

Loads table, auto-connect record, sequence, and collation table definitions.

Table Contents (.d file)...

Loads table contents.

SQL Views...

Loads SQL view contents.

User Table Contents...

Loads user table contents.

Sequences Current Values...

Loads sequence values.

Reconstruct Bad Load Records...

Uses the error file and the original data file to build a new data file for bad records.

Load Data and Definitions Data Definitions (.df file)

Choose this option to load table and sequence definitions for selected tables. The DF file contains the definitions of tables, which can include fields, indexes, sequences, auto-connect records, collate/translate tables, and all their characteristics. Progress prompts you for the filename that contains the data definitions you want to load into your current working database. The default file is the working physical database name with a .df extension.

You can specify whether you want to stop the load as soon as Progress encounters a bad definition statement. Progress displays each item as it loads the definitions for that object. Progress displays a status message and prompts you to continue. Progress truncates table names to eight characters.

NOTE: When you choose Load Data Definitions Data Definitions from the menu bar, Progress automatically loads all the table definitions, including any collation or translation tables. If you change the collate/translate tables, you must rebuild your indexes.

Load Data and Definitions Table Contents (.d file)

Choose this option to load table contents. Progress alphabetically lists all the tables defined for your database. After you select the tables whose contents you want to load, Progress prompts you for the name of the contents file or, if there is more than one, the name of the directory that contains the contents files.

If you load table contents for a single table, Progress displays a default name for the file from which you can load your table contents. This default file is always the name of the table dump file, usually the table name with a .d extension.

When you load the contents of more than one table, Progress prompts you for a directory from which it loads 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-name.d file.

Progress also prompts you for an acceptable 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. If you specify an error rate of 10 percent, Progress must successfully load 90 records from every set of 100 records loaded. If the error rate exceeds the specified rate, Progress terminates the load. Progress places bad records in the table-name.e file.

If the definition file does not specify a code page, Progress prompts you for one.

NOTE: You can move and reorganize data by performing a binary dump and load. The binary method improves the dump and load performance significantly because the data remains in binary format during the process. For more information about performing a binary dump and load, see Database Tasks."

Load Data and Definitions SQL Views

Choose this option to load SQL view contents. Progress prompts you for the filename from which it reads the view contents. The default filename is _view.d. Specify the filename. Progress displays a status message and prompts you to continue.

Load Data and Definitions User Table Contents

Choose this option to load user information. Progress prompts you for the filename from which it reads the user table contents. The default filename is _user.d. Specify the filename. Progress displays a status message and prompts you to continue.

Load Data and Definitions Sequences Current Values

Choose this option to load sequence values. Progress prompts you for the filename from which it reads the sequence values. The default filename is _seqvals.d. Specify the filename. Progress displays a status message and prompts you to continue.

Load Data and Definitions Reconstruct Bad Load Records

Choose this option to build a new data file for bad records from the error file and original data file. If Progress encounters errors while loading a data file, it creates the error file. When you choose this option, the dialog box in Figure 10–3 appears.

Figure 10–3: Reconstruct Bad Load Records Dialog Box

This dialog box contains the following user-interface elements:

Original Data File

Specifies the name of the file that contains the original data.

Error File

Specifies the name of the error file.

Output Data File

Specifies the name of the new data file. The default filename is error.d.

Progress builds the new file. You can use a text editor to edit the new data file and fix the bad records after Progress builds the new file. Once you have fixed the records, you can reload the file.


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