•  Preface
  • Purpose
  • Audience
  • Organization
  •  Using this manual
    • References to ABL compiler and run-time features
    • References to ABL data types
  •  Typographical conventions
    • SQL syntax conventions
  •  Examples of syntax descriptions
    • Long syntax descriptions split across lines
    • Complex syntax descriptions with both required and optional elements
  •  Examples of SQL syntax diagrams
    • Long SQL syntax descriptions split across lines
  •  OpenEdge messages
    • Obtaining more information about OpenEdge messages
•  Introducing multi-tenancy
  • What is multi-tenancy?
  • What are the advantages of multi-tenancy?
  • What is a tenant?
  •  How does data access work?
    • Partition allocation
    •  Table types
      • Multi-tenant objects
      • Object allocation
      • Allocation states
      • Multi-tenant table instance
      • Data partitions
      • Default storage area
      • Multi-tenant sequences
  • What is a multi-tenant group?
•  Multi-tenant feature capabilities
  • Database Administration Console
  • Data Dictionary support for multi-tenancy
  • Database Administration
  • Database utilities
  • Auditing
  • Progress Developer's Studio for OpenEdge support
•  Multi-tenancy and ABL
  •  ABL Support
    • Running applications in a multi-tenant database environment
    •  Coding for super-tenant access
      • Super-tenant effective tenant
      • Super-tenant applications
      • Super-tenant queries
      • Super-tenant data updates
      • Tenancy identification
      • Super-tenant sequence access
    • Using multi-tenant sequences with shared tables
  •  ABL API for multi-tenant maintenance
    • DataAdminService operations
    • Entity interface members
    • Further information
•  Multi-tenancy and OpenEdge SQL
  • OpenEdge SQL support
  •  DBA use cases
    • Define a multi-tenant table
    • Define a multi-tenant sequence
    • Define a multi-tenant Index
    • Alter a regular table to a multi-tenant table
    • Alter a multi-tenant sequence
    • Create a tenant
    • Create a super tenant
    • Alter a tenant
    • Delete a tenant
  • Regular tenant use case (accessing data)
  •  Super tenant use cases
    • Access data as a super tenant
    • Join multi-tenant tables
    • Insert rows into a multi-tenant table
    • Move rows between partitions in a multi-tenant table
    • Update rows of a tenant partition
    • Delete rows of a tenant partition
    • View tenant specific information
  •  SQL utility use cases
    • Dumping tenant data as a regular tenant
    • Dumping all tenant data as a super tenant or a DBA
    • Loading tenant data as a regular tenant
    • Loading tenant data as a super tenant or a DBA
    • Writing schema definitions for a multi-tenant table
•  Multi-tenancy documentation map
  • Additional multi-tenant information
• Data partitions
• Default storage area
• Domain access code
• Group/multi-tenant group
• Multi-tenant objects
• Multi-tenant sequence
• Object allocation/allocation state
• Allocation states
• Security domains
• Table types
• Tenants
• Tenant ID
• Tenancy
• Tenant identity