Upcoming Webinar in German on July 12: Datensilos in einer Hochgeschwindigkeits-Logistikumgebung beseitigen

Register now

The book SQL-99 Complete, Really is brought to you by

Crate.io Logo White
Try CrateDB Cloud for free

Learn more about CrateDB

Toggle Doc Menu
Search
    • SQL-99 Complete, Really
      • Preface
        • Who Should Read this Book?
        • What’s In It?
      • Chapters
        • Chapter 1 – Introduction
        • Chapter 2 – General Concepts
        • Chapter 3 – Numbers
        • Chapter 4 – Bit strings
        • Chapter 5 – Binary strings
        • Chapter 6 – Characters
        • Chapter 7 – Character strings
        • Chapter 8 – Temporal values
        • Chapter 9 – Boolean values
        • Chapter 10 – Collection types
        • Chapter 11 – Row types
        • Chapter 12 – Reference types
        • Chapter 13 – NULLs
        • Chapter 14 – SQL Cluster
        • Chapter 15 – SQL Authorizationid
        • Chapter 16 – SQL Catalogs
        • Chapter 17 – SQL Schema
        • Chapter 18 – SQL Table and View
        • Chapter 19 – SQL Domain
        • Chapter 20 – SQL Constraint and Assertion
        • Chapter 21 – SQL Character Set
        • Chapter 22 – SQL Collation
        • Chapter 23 – SQL Translation
        • Chapter 24 – SQL Trigger
        • Chapter 25 – SQL-invoked Routine
        • Chapter 26 – PSM: Not just Persistent Stored Modules
        • Chapter 27 – User-defined Types
        • Chapter 28 – Introduction to SQL-data operations
        • Chapter 29 – Simple Search Conditions
        • Chapter 30 – Searching with Joins
        • Chapter 31 – Searching with Subqueries
        • Chapter 32 – Searching with Set Operators
        • Chapter 33 – Searching with Groups
        • Chapter 34 – Sorting Search Results
        • Chapter 35 – Changing SQL-data
        • Chapter 36 – SQL Transactions
        • Chapter 37 – SQL Transaction Concurrency
        • Chapter 38 – SQL Sessions
        • Chapter 39 – Embedded SQL Binding Style
        • Chapter 40 – SQL/CLI Binding Style
        • Chapter 41 – SQL/CLI: env Functions
        • Chapter 42 – SQL/CLI: dbc Functions
        • Chapter 43 – SQL/CLI: stmt Functions
        • Chapter 44 – SQL/CLI Statement Functions
        • Chapter 45 – SQL/CLI: Cursor Functions
        • Chapter 46 – SQL/CLI: desc Functions
        • Chapter 47 – SQL/CLI: Diagnostic Functions
        • Chapter 48 – SQL/CLI: General Functions
        • Chapter 49 – SQL/CLI: Deferred Parameter Functions
        • Chapter 50 – SQL/CLI: Locator Functions
        • Chapter 51 – SQL/CLI: Catalog Functions
        • Chapter 52 – Module Binding Style
        • Chapter 53 – Style
      • Appendices
        • Appendix A – Remote Database Access
        • Appendix B – SQL Taxonomy
        • Appendix C – Non-portable SQL Features
        • Appendix D – Incompatibilities with SQL-92
        • Appendix E – SQL Web Sites
        • Appendix F – Glossary
        • Appendix G – Errata
v:latest
latest

Appendices¶

Note

You are reading a digital copy of SQL-99 Complete, Really, a book that documents the SQL-99 standard.

For more information specific to CrateDB, check out the CrateDB Reference.

Table of Contents

  • Appendix A – Remote Database Access
    • ISO/IEC 9759
    • TCP/IP
    • The Client/Server Model
      • RDAConnect
      • RDADisconnect
      • RDAEndTran
      • RDAClientAttribute
      • RDAStatementPrepare
      • RDAStatementDeallocate
      • RDAStatementExecute
      • RDAStatementExecDirect
      • RDAStatementFetchRows
      • RDAStatementCloseCursor
      • RDAStatementCancel
    • A Short Session
    • Making it hard
    • What good is RDA?
  • Appendix B – SQL Taxonomy
    • Core SQL Notes
    • Taxonomy Tables
      • Table Tax_1: SQL/Foundation Feature Taxonomy
      • Table Tax_2: SQL/CLI Feature Taxonomy
      • Table Tax_3: SQL/PSM Feature Taxonomy
      • Table Tax_4: SQL/Bindings Feature Taxonomy
  • Appendix C – Non-portable SQL Features
    • Implementation-Defined Features
      • Overall Method of SQL Support
      • Connection and Session Results
      • Parsing/Display
      • Names
      • Defining <literal>s
      • BEGIN … END: Compound Statement
      • SIGNAL Statement
      • RESIGNAL Statement
      • CASE Statement
      • IF Statement
      • LOOP Statement
      • LEAVE Statement
      • WHILE Statement
      • REPEAT Statement
      • Diagnostics
    • Implementation-Dependent Features
  • Appendix D – Incompatibilities with SQL-92
  • Appendix E – SQL Web Sites
  • Appendix F – Glossary
    • Glossary Entries
      • A
      • B
      • C
      • D
      • E
      • F
      • G
      • H
      • I
      • J
      • K
      • M
      • G
      • H
      • I
      • S
      • T
      • U
      • V
      • X
      • Y
  • Appendix G – Errata
    • SQL Foundation
    • SQL/CLI
crate.io Logo
  • About
  • Imprint
  • Contract
  • Legal
Follow us
Follow us on Twitter Follow us on LinkedIn Follow us on Facebook Follow us on Instagram Follow us on Facebook

Subscribe to the Crate.io Newsletter now