Overview of SQL Language Reference

Basic Language Elements

Describes the basic language elements of SQL, including characters, tokens, identifiers, naming conventions, authorization ID, USER, values, data types, basic operations (assignment and comparison), literals, column names, host variables and indicator variables. Includes examples for most language elements.

Functions

Describes column and scalar functions and provides a syntax diagram of this basic language element, plus examples.

Expressions

Describes expressions and provides a syntax diagram of this basic language element, plus examples. Also discusses expressions without arithmetic operators, with arithmetic operators and conversions between data types during arithmetic operations, and the precedence of operations.

Predicates

Describes predicates, including the basic predicate, quantified predicate, BETWEEN predicate, LIKE predicate, EXISTS predicate, IN predicate and NULL predicate, and provides a syntax diagram of each predicate, plus examples.

Search Conditions

Describes search conditions and provides a syntax diagram of this basic language element, plus examples. Includes information on Boolean operators.

SQL Statements

Describes the various SQL statements and gives syntax diagrams and examples of each.