Preface
Purpose
Audience
Organization
Using this manual
Typographical conventions
Examples of syntax descriptions
OpenEdge messages
Data Dictionary Basics
Starting the Data Dictionary
Data Dictionary menu bar
Database Tasks
Creating a database
Connecting to a database
Switching to another connected database
Disconnecting a database
Viewing session information
Dumping data definitions
Creating an incremental data definition file
Creating a parameter file
Editing a parameter file
Loading data definitions
Table Tasks
Creating a table
Specifying validation criteria
Specifying triggers
Specifying string attributes
Modifying a table
Deleting a table
Freezing or unfreezing a table
Generating a table report
Generating a Detailed Table Report
Generating a Quick Table Report
Generating a Table Relations Report
Dumping table contents
Dumping data from a multi-tenant database
Loading table contents
Reconstructing bad load records
Loading data into a multi-tenant database
Binary dump and load
Performing the binary dump
Performing the binary load
Creating a bulk loader description file
Generating an include file
Field Tasks
Adding a field
Modifying a field
Changing a field data type from integer to INT64
Changing a field name globally
Copying a field
Deleting a field
Changing field order
Generating a Quick Field Report
Adjusting the Field Width
Index Tasks
Creating an index
Modifying an index
Changing the primary index for a table
Renaming an index
Deactivating an index
Deleting an index
Generating a Quick Index Report
Sequence Tasks
Support for 64-bit sequences
Creating a sequence
Modifying a sequence
Deleting a sequence
Dumping sequence definitions
Dumping sequence current values
Loading sequence current values
Generating a sequence report
Trigger Tasks
Creating a trigger
Modifying a trigger
Deleting a trigger
Generating a trigger report
Database Menu Reference
Database menu
Select Working Database option
Create option
Connect option
Disconnect option
Reports option
Detailed Table Report option
Quick Table Report option
Quick Field Report option
Quick Index Report
Sequence Report option
Trigger Report option
User Report option
Table Relations Report option
Storage Areas Report option
Verify Data Width Report option
Alternate Buffer Pool Report option
Auditing Reports option
Track Audit Policy Changes report
Track Database Schema Changes report
Track Audit Data Administration (Dump/Load) report
Track Application Data Administration (Dump/Load) report
Track User Account Changes report
Track Security Permissions Changes report
Track SQL Permissions Changes report
Track Authentication System Changes report
Client Session Authentication report
Database Administration Utilities report
Database Access report (Login/Logout/etc)
Track Encryption Policy Changes report
Track Key-store Changes report
Database Encryption Administration (Utilities) report
Custom Audit Data Filter report
OpenEdge Auditing Report Options dialog box
Encryption Policy Reports option
Quick Encryption Policies report
Detailed Encryption Policies report
Exit option
Schema Menu Reference
Schema menu
Modify Table option
Validation option
Table Triggers option
String Attributes option
Add New Table option
Delete Table(s) option
Field Editor option
Add
Field Triggers
View As
GoIndex option
Reorder Fields option
Global Field Name Change option
Index Editor option
Sequence Editor option
Adjust Field Width option
Admin Menu Reference
Admin menu
Dump Data and Definitions option
Data Definitions (.df file) option
Table Contents (.d file) option
SQL Views option
User Table Contents option
Security Domains option
Security Permissions option
Auto‑Connect Records Only option
Collation Tables option
Sequences Definitions option
Sequences Current Values option
Database Identification Properties option
Database Options
Audit Policies option
Dump as XML
Dump as Text
Application Audit Events
Audit Data option
Create Incremental .df File option
Batch Incremental utility
Load Data and Definitions option
Data Definitions (.df file) option
Table Contents (.d file) option
SQL Views option
User Table Contents option
Security Domains option
Security Permissions option
Sequences Current Values option
Reconstruct Bad Load Records option
Database Identification Properties option
Database Options option
Audit Policies option
Load as XML
Load as Text option
Application Audit Events option
Audit Data option
Database Identification option
Database Identification Maintenance option
New Database Passkey/Identifier dialog box
Database Identification History option
Security option
Edit User List option
Change your password
Edit Data Security
Edit Audit Permissions option
Security Administrators option
Disallow Blank User Access option
User Report option
Domain Maintenance option
Authentication Systems
Domains
Encryption Policies
Edit Encryption Policy
Generate Encryption Keys
Encryption Policy History
Export Data option
Import Data option
Fixed-Length option
dBASE Definitions option
Create Bulk Loader Description File option
Database options
Enabling large key entries
Alternate Buffer Pool Maintenance
Advanced Menus Reference
DataServer menu
Utilities menu
Editor for Parameter Files option
Quoter Functions option
Entire Lines option
By Delimiter option
By Column Ranges option
Generate Include Files option
ASSIGN Statement option
FORM Statement option
DEFINE WORK-TABLE Statement option
Edit OpenEdge Auto-Connect List option
Freeze/Unfreeze Table option
Index Deactivation option
Information option
PRO/SQL menu options
PRO/SQL View Report option
Dump as CREATE VIEW Statement option
Dump as CREATE TABLE Statements option
Tools menu
OpenEdge® Development:Basic Database Tools
Tools menu