15.00 - Appendix A Notation Conventions - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)

This appendix describes the notation conventions used in this book.

This book uses three conventions to describe the SQL syntax and code:

 

Convention

Description

Syntax diagrams

Describes SQL syntax form, including options.

For details, see “Syntax Diagram Conventions” on page 1365.

Square braces in the text

Represent options. The indicated parentheses are required when you specify options.

For example:

  • DECIMAL [(n[,m])] means the decimal data type can be defined optionally:
  • without specifying the precision value n or scale value m
  • specifying precision (n) only
  • specifying both values (n,m)
  • You cannot specify scale without first defining precision.

  • CHARACTER [(n)] means that use of (n) is optional.
  • The values for n and m are integers in all cases.

    Japanese character code shorthand notation

    Represent unprintable Japanese characters.

    For details, see “Character Shorthand Notation Used In This Book” on page 1370.

    Symbols from the predicate calculus are also used occasionally to describe logical operations. For details, see “Predicate Calculus Notation Used In This Book” on page 1372.