SQL Reference

The following table provides a summary of the available topics.
datacom
The following table provides a summary of the available topics:
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.
Describes column and scalar functions and provides a syntax diagram of this basic language element, plus examples.
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.
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.
Describes search conditions and provides a syntax diagram of this basic language element, plus examples. Includes information on Boolean operators.
Describes the various SQL statements and gives syntax diagrams and examples of each.
Describes the methods by which each SQL statement can execute.