Chapter 2 Getting Started with ISQL

Table of Contents

Invoking ISQL

Starting a DBE Session

Leaving ISQL

Managing Transactions

How ISQL Manages Transactions

Using SQL SAVEPOINT and ROLLBACK WORK Statements

Using SQL and ISQL Commands

Terminating Commands

Prompting Mode

Aborting Commands

Special Characters in Commands

Parameters in Commands

Using ISQL Files and Buffers

Entering Interactive Commands from the Terminal

Files Containing Commands

The Command Buffer

The Command History Buffer

Using a Synonym File

Getting Help

Setting Command Options

Using Other Programs within ISQL

Using the System Editor

Using System Commands and Programs

Using SQLUtil

Using SQLGEN

Handling Errors

Command Errors

DBEnvironment Errors

Unexpected ISQL or DBEnvironment Termination

Checking the Exit Status

• Invoking ISQL.

• Starting a DBE Session.

• Leaving ISQL.

• Managing Transactions.

• Using SQL and ISQL Commands.

• Using ISQL Files and Buffers.

• Getting Help.

• Setting Command Options.

• Using Other Programs within ISQL.

• Handling Errors.