Structure of the SESAM/SQL server documentation

The documentation for the SESAM/SQL server database system can be found in the following manuals:

• Core manual
  This manual provides an overview of the database system and describes basic principles, concepts, interrelationships, and technical terms. It provides the basis for understanding all the other SESAM/SQL manuals.

• SQL Reference Manual Part 1: SQL Statements
  The manual deals with the embedding of programs and describes the syntax and semantics of the SQL language constructs in alphabetical order.

• SQL Reference Manual Part 2: Utilities
  The utility statements are not included in this alphabetical list and are dealt with separately in the “SQL Reference Manual, Part 2: Utilities”.

• CALL DML Applications
  This manual is aimed at CALL DML programmers and describes the language elements used in the CALL DML interface and explains how to create CALL DML programs.

• Database Operation
  This manual is aimed at the system administrator and covers database operation. It includes details on starting and terminating the DBH and SESDCN and the associated load options and administration statements. The manual also describes the utilities required for database operation.

• Utility Monitor
  This manual describes how to use the utility monitor and the functions it provides. The utility monitor is a component part of SESAM/SQL and provides a menu-driven interface for creating, loading, backing up and reconstructing a database using SQL statements. The utility monitor also provides simple methods of querying the metadata.

• Messages
  The message manual contains information relating to the structure and invocation of messages for the SESAM/SQL server database system and the distribution component SESAM/SQL-DCN. The SQLSTATEs and CALL DML status messages are listed in full here.

• Performance
  This manual is aimed at experienced SESAM/SQL users. It describes how users can identify performance bottlenecks and indicates which parameters can be used to influence system performance.

The following manual describes how to create ESQL-COBOL programs:

• ESQL-COBOL User Guide

The following manuals describe remote access with SESAM-DBAccess:

• SESAM-DBAccess

To search for terms, a PDF index of the SESAM/SQL manuals is integrated into the product SESAM/SQL-Server.

Demonstration database

Included in the SESAM/SQL-Server delivery is the library SIPANY.SESAM-SQL.<ver>.MAN-DB. This library contains all the components that you need to try out the examples in the manuals yourself.

These include:

• Readme files with an overview of the present files

• Start procedures to start the necessary SESAM/SQL programs

• Files relating to the constructed sample database ORDERCUST

• Instruction files and ESQL-COBOL programs with runtime examples of important database statements

If an example in the manual is accompanied by the symbol on the left, this means that it is present as a component in an instruction file or an ESQL-COBOL program in the library.

The demonstration database is described in chapter “Demonstration database”.