SQL Reference

Related Documentation for This Book

The following publications may prove useful in preparing applications:

• Administration Guide
  • Contains information required to design, implement, and maintain a database to be accessed either locally or in a client/server environment.
• Application Development Guide
  • Discusses the application development process and how to code, compile, and execute application programs that use embedded SQL and APIs to access the database.
• Spatial Extender User's Guide and Reference
  • Discusses how to write applications to create and use a geographic information system (GIS). Creating and using a GIS involves supplying a database with resources and then querying the data to obtain information such as locations, distances, and distributions within areas.
• IBM SQL Reference
  • This manual contains all the common elements of SQL that span across IBM's library of database products. It provides limits and rules that assist in preparing portable programs using IBM databases. It provides a list of SQL extensions and incompatibilities among the following standards and products: SQL92E, XPG4-SQL, IBM-SQL and the IBM relational database products.
• American National Standard X3.135-1992, Database Language SQL
  • Contains the ANSI standard definition of SQL.
• ISO/IEC 9075:1992, Database Language SQL
  • Contains the 1992 ISO standard definition of SQL.
• ISO/IEC 9075-2:1999, Database Language SQL -- Part 2: Foundation (SQL/Foundation)
  • Contains a large portion of the 1999 ISO standard definition of SQL.
• ISO/IEC 9075-4:1999, Database Language SQL -- Part 4: Persistent Stored Modules (SQL/PSM)
  • Contains the 1999 ISO standard definition for SQL procedure control statements.
• ISO/IEC 9075-5:1999, Database Language SQL -- Part 4: Host Language Bindings (SQL/Bindings)
  • Contains the 1999 ISO standard definition for host language bindings and dynamic SQL.