Try OpenEdge Now
skip to main content
Basic Database Tools
Admin Menu Reference : Dump Data and Definitions option : Table Contents (.d file) option
 

Table Contents (.d file) option

Choose this option to dump table contents. The Data Dictionary alphabetically lists all the tables defined for your database.
Note: The .d file can exceed 2GB on platforms where the ABL client supports large files.
When you select only one table, the Data Dictionary displays the Dump Data Contents dialog box for that table. If you select multiple tables, the Data Dictionary displays the Dump Data Contents for Some Tables dialog box, as shown in the following figure:
Figure 39. Dump Data Contents for Some Tables dialog box
The Dump Data Contents for Some Tables dialog box contains the following fields:
*Output Directory or Output File — Specifies the output directory if you choose to dump multiple tables. Specifies the output file if you choose to dump only one table. The default filename for each table is the dump filename you specified when you created the table, or table-name.d.
*Include LOB — The Data Dictionary also provides the option of dumping LOBs.
*LOB Directory — If you select yes in the Include LOB field, you must specify the name of the LOB directory.
*Character Mapping — Specifies the type of character mapping:
*Default Map — Specifies the default mapping.
*Map — Specifies the character mapping. Enter the type of mapping in the fill-in field. For example, MAP laserwriter/french or MAP hp2/spanish/italian.
*NO MAP — Specifies not to perform any character mapping.
*Code Page — Specifies the default code page (character set). A code page maps characters to numbers (code-points) and defines the character's visual representation (glyph). Code pages usually represent a particular language's alphabet, such as the ibm861 code page (Icelandic).
The Data Dictionary displays each table name as it writes the table contents to the file's contents file. The Data Dictionary displays a status message and prompts you to continue.
If your database is enabled for multi-tenancy, you can dump your data on a per-tenant basis. The Dump Data Contents for Some Tables dialog is modified as shown in the following figure:
Figure 40. Dump Data Contents for Some Tables (multi-tenant)
The Dump Data Contents for Some Tables dialog box, when your database is enabled for multi-tenancy, contains the following fields:
*Effective Tenant — Specifies the tenant of the data. Enter a name or choose Select Tenant to select a tenant from a list.
*Use Default Location — Check box to indicate that the data should be dumped to the identified default location based on the tenant name.
*Root Directory — Enter a directory name to dump data contents for the selected tables in the identified subdirectories. The default filename for each table is either the dump filename you specified when you created the table or table-name.d.
*Include LOB — The Data Dictionary also provides the option of dumping LOBs.
*Shared LOB/Tenant LOB Directory — If you select yes in the Include LOB field, and you are not using the default location, you must specify the name of the LOB directories.