•  Preface
  • Purpose
  • Audience
  • Organization
  •  Using this manual
    • References to ABL compiler and run-time features
    • References to ABL data types
  •  Examples of syntax descriptions
    • Long syntax descriptions split across lines
    • Complex syntax descriptions with both required and optional elements
  •  OpenEdge messages
    • Obtaining more information about 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 user table contents
    • Dumping data from a multi-tenant database
  •  Loading table contents
    • Loading user 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
    • Creating a FORM statement include file
    • Creating a DEFINE WORK-TABLE statement 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
  • Creating a trigger from an existing field
  •  Modifying a trigger
    • Modifying a table trigger
    • Modifying a field trigger
  •  Deleting a trigger
    • Deleting a table trigger
    • Deleting a field 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