This manual contains a complete description of the SQL database language as used in the database system SESAM/SQL. Specific reference is made to any differences to or extensions of the SQL standard.
The chapter “Embedding of SQL in programs” describes SQL-specific concepts for using SQL statements in a host language (COBOL). The remaining chapters describe SQL language constructs in logical sequence. In each chapter, it is assumed that you are familiar with the language constructs dealt with in the previous chapters and are not described again.
The chapter “SQL statements” includes an alphabetical reference section containing all the SQL statements.
The chapter “SESAM-CLI” describes the structure of the SESAM-CLI interface. This interface is used to create and edit BLOB objects. It also includes an alphabetical reference section which explains the individual CLI calls in detail.
The chapter “Information schemas” describes the views of the INFORMATION_SCHEMA and SYS_INFO_SCHEMA schemas.
The appendix is an alphabetical reference section for the syntaxes used and reserved keywords of SESAM/SQL.
A list of references and an index is provided at the end of the manual.
The manual contains a large number of examples. These refer in each case to the content of the preceding description. Some of the examples for SQL language constructs, particularly those for expressions and query expressions, run only in a superordinate statement and are not executable independently.