DB2 Server for VSE & VM: Interactive SQL Guide and Reference

About This Manual

This manual is a tutorial and reference for IBM DB2 Server for VSE & VM interactive SQL (ISQL) users in a Virtual Storage Extended/Enterprise Systems Architecture (VSE/ESA) or Virtual Machine/Enterprise Systems Architecture (VM/ESA) environment. The manual presents reference information for particular topics, followed by tutorial exercises that illustrate the reference information. Screen images (hereafter referred to as displays) that are similar to the displays that you view when performing ISQL exercises are included in the text.

The manual begins with an introduction to:

• The DB2 Server for VSE & VM relational database management system (RDBMS).
• The Structured Query Language (SQL) which manipulates and controls data managed by the RDBMS.
• The Interactive SQL (ISQL) facility, through which SQL statements are issued from a display terminal.

The manual continues with query and management techniques for DB2 Server for VSE & VM tables that are used during an ISQL session. Specific guidelines are provided for the use of ISQL commands, SQL statements, routines, and VM functions.

The examples and exercises that are provided throughout this manual to familiarize you with ISQL are supplemented by answers and example table layouts, both of which are in appendixes.

Note:

• The terms DB2 Server for VM, DB2 Server for VSE, and DB2 Server for VSE & VM are used in this guide to refer to DB2 Server for VM Version 7 Release 1 unless otherwise indicated.
• When the term CICS is used in this manual, CICS/VSE is implied. The CICS/VSE product is required for DBCS support.
• |The term VSE refers to VSE/Enterprise Systems |Architecture Version 2 Release 3 or later.
• |The term VM is used in this guide to refer to VM/ESA |Version 2 Release 2 or later.

For a quick summary of reference information on ISQL functions, refer to the DB2 Server for VSE & VM Quick Reference manual.