Chapter 2 Using ALLBASE/SQL

Table of Contents

Creating DBEnvironments

Specifying a Native Language Parameter

Initial Privileges

Starting and Terminating a DBE Session

Sessions with Autostart

Sessions without Autostart

Terminating DBE Sessions

Using ALLBASE/SQL in a Diskless Cluster

Creating Physical Storage

Defining How Data is Stored and Retrieved

Creating a Table

Specifying a DBEFileSet

Specifying Native Language Tables and Columns

Creating a View

Creating Indexes

Specifying Integrity Constraints

Creating Procedures

Creating Rules

Understanding Data Access Paths

Serial Access

Indexed Access

Hashed Access

Differences between Hashed and Indexed Access

When to Use a Hash Structure

TID Access

Controlling Database Access

Authorities

Obtaining Authorization

DBA Authority

Grants

Grantable Privileges

Ownership

Default Owner Rules

Ownership Privileges

Authorization Groups

Classes

Differences between Groups and Classes

Manipulating Data

Inserting Data

Updating Data

Deleting Data

Managing Transactions

Objectives of Transaction Management

Starting Transactions

Ending Transactions

Using SAVEPOINT

Scoping of Transaction and Session Attributes

Transaction Limits and Timeouts

Monitoring Transactions

Tips on Transaction Management

Auditing DBEnvironments

Partitions in Audit DBEnvironments

Using Wrapper DBEnvironments

Using SQLAudit

Application Programming

Preprocessor

Authorization

DBEnvironment Changes

Host Variables

Multiple-Row Manipulations

Using Multiple Connections and Transactions with Timeouts

Connecting to DBEnvironments

Setting the Current Connection

Setting Timeout Values

Setting the Transaction Mode

Disconnecting from DBEnvironments

Administering a Database

Understanding the System Catalog

• Creating DBEnvironments

• Starting and Terminating a DBE Session

• Creating Physical Storage

• Defining How Data is Stored and Retrieved

• Understanding Data Access Paths

• Controlling Database Access

• Manipulating Data

• Managing Transactions

• Auditing DBEnvironments (including setting up partitions)

• Using Wrapper DBEnvironments

• Using SQLAudit

• Application Programming

• Using Multiple Connections and Transactions with Timeouts

• Administering a Database

• Understanding the System Catalog

• SQL Queries

• Constraints, Procedures and Rules

• Concurrency Control