The following information provides a brief description of each chapter and appendix in the manual.
The Summary of Changes summarizes the technical and library changes made for Version 7 Release 1 of the database manager product.
Chapter 1, Getting Started, introduces the database manager, SQL, and ISQL facilities, and takes the reader through a typical ISQL session using the display terminal.
Chapter 2, Querying Tables, discusses the presentation of queried information both on the display and in a printed report.
Chapter 3, Managing Table Data, provides DB2 Server for VSE & VM table management guidelines for table changes.
Chapter 4, Using ISQL Commands to Save Time When Executing Statements, explains the use of ISQL commands with SQL statements during an ISQL session.
Chapter 5, Formatting Query Results, offers additional methods of displaying queried information. Formatting techniques for both the display and for printed reports are discussed in detail.
Chapter 6, Storing SQL Statements, describes the use of stored SQL statements, including management and processing methods.
Chapter 7, Creating and Using Routines, discusses the use of database manager routines to process a series of ISQL commands or SQL statements.
Chapter 8, Creating and Managing Tables, describes procedures to create and maintain a personal set of database manager tables with an emphasis on the use of table keys. In addition, information is provided that explains the sharing of tables with other database manager users. Guidelines that improve query performance are also provided.
| DB2 Server for VM |
|---|
|
Chapter 9, Using VM Functions, discusses the use of VM commands and functions to enhance the ISQL session, such as the specification of the number of copies of printed reports. |
Chapter 10, ISQL Commands, is a reference chapter for ISQL commands that provides a format diagram, a description, and an example, where appropriate, for each command.
Appendix A, Answers to the Exercises, contains the answers to the exercises in the manual.
Appendix B, Sample Tables, describes the structure and contents of the sample database manager tables used in the examples and exercises in the manual.
Appendix C, Summary of ISQL PF Keys, describes the ISQL commands associated with the PF keys on the keyboard.
Appendix D, Summary of SQL Statements for Interactive Use, lists the SQL statements that you can refer to the DB2 Server for VSE & VM SQL Reference manual, if you want more information.
| DB2 Server for VSE |
|---|
|
Appendix E, Suppressing the ISQL Sign-On Display for DB2 Server for VSE, gives you information on suppressing the ISQL sign-on display and related terminal messages. |
The Bibliography lists the full titles and order numbers of related publications, and is followed by the Index.