SQL Reference

How This Book is Structured

This reference manual is divided into two volumes. Volume 1 contains the following sections:

• Introduction, identifies the purpose, the audience, and the use of the book.
• Concepts, discusses the basic concepts of relational databases and SQL.
• Language Elements, describes the basic syntax of SQL and the language elements that are common to many SQL statements.
• Functions, contains syntax diagrams, semantic descriptions, rules, and usage examples of SQL column and scalar functions.
• Queries, describes the various forms of a query.
• The appendixes included in Volume 1 contain the following information:
  • Appendix A, SQL Limits contains the SQL limitations
  • Appendix B, SQL Communications (SQLCA) contains the SQLCA structure
  • Appendix C, SQL Descriptor Area (SQLDA) contains the SQLDA structure
  • Appendix D, Catalog Views contains the catalog views for the database
  • Appendix E, Catalog Views For Use With Structured Types contains the structured type catalog views for the database
  • Appendix F, Federated Systems contains options and type mappings for Federated Systems
  • Appendix G, Sample Database Tables contains the sample tables used for examples
  • Appendix H, Reserved Schema Names and Reserved Words contains the reserved schema names and the reserved words for the IBM SQL and ISO/ANS SQL92 standards
  • Appendix I, Comparison of Isolation Levels contains a summary of the isolation levels.
  • Appendix J, Interaction of Triggers and Constraints discusses the interaction of triggers and referential constraints.
  • Appendix K, Explain Tables and Definitions contains the Explain tables and how they are defined.
  • Appendix L, Explain Register Values describes the interaction of the CURRENT EXPLAIN MODE and CURRENT EXPLAIN SNAPSHOT special register values with each other and the PREP and BIND commands.
  • Appendix M, Recursion Example: Bill of Materials contains an example of a recursive query.
  • Appendix N, Exception Tables contains information on user-created tables that are used with the SET INTEGRITY statement.
  • Appendix O, Japanese and Traditional-Chinese EUC Considerations lists considerations when using EUC character sets.
  • Appendix P, BNF Specifications for DATALINKs contains the BNF specifications for DATALINKs.

Volume 2 contains the following sections:

• SQL Statements, contains syntax diagrams, semantic descriptions, rules, and examples of all SQL statements.
• SQL Procedures, contains syntax diagrams, semantic descriptions, rules, and examples of SQL procedure statements.