Purpose

OpenEdge Data Management: SQL Development provides information for developers who are using SQL within the OpenEdge application development environment. The information in this manual is also useful for database administrators, and, to a lesser degree, to application end users.

Audience

The audience for this book is composed of three specific groups:

  • Database Administrators who will use the book to:
    • Create and maintain databases and database objects.
    • Create, modify, and revoke user privileges.
    • Tune database performance.
    • Perform installation and setup of servers and clients.
  • Application developers who will use the book to:
    • Manage database connections and set up data sources.
    • Create queries to draw information from the database.
    • Tune database queries.
    • Develop application business logic.
  • End users who will use the book to:
    • Connect to databases.
    • Issue queries.
    • Understand error messages.

Ogranization

Introduction

Provides an overview of OpenEdge SQL and the OpenEdge SQL client/server architecture.

JDBC Client

Presents an overview of the JDBC client, details on setting environment variables, and procedures for connecting to a database with the JDBC driver.

ODBC Client

Offers an overview of the ODBC client and information on configuring data source.

Data control language and security

Reviews information on working with database security, creating users, and granting, modifying, and revoking privileges.

OpenEdge SQL data definition language

Furnishes information on OpenEdge SQL database structure and methods for creating, altering, and dropping database objects.

OpenEdge SQL data manipulation language

Provides information on the Data Manipulation Language statements, indexes, and join operations.

OpenEdge SQL and Advanced Business Language Interoperability

Addresses the interoperability of ABL and OpenEdge SQL.

Data control language and transaction behavior

Summarizes information on transactions, isolation levels, and locking.

Perform multi-database queries

Provides information on the performance of multi-database queries.

Work with JTA transactions

Provides information on performing JTA transactions

Stored procedures and triggers

Provides information on using stored procedures and triggers.

Optimize query performance

Presents information on the operation of the SQL Query Optimizer and offers recommendations on how to get the best out of its performance.

Documentation conventions

See Documentation Conventions for an explanation of the terminology, format, and typographical conventions used throughout the OpenEdge content library.