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