15.00 - SQL Functional Families and Binding Styles - Teradata Database

Teradata Database SQL Fundamentals

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1141-015K

SQL Functional Families and Binding Styles

The SQL language can be characterized in several different ways. This chapter is organized around functional groupings of the components of the language with minor emphasis on binding styles.

Functional Family

SQL provides facilities for defining database objects, for defining user access to those objects, and for manipulating the data stored within them.

The following list describes the principal functional families of the SQL language.

  • SQL Data Definition Language (DDL)
  • SQL Data Control Language (DCL)
  • SQL Data Manipulation Language (DML)
  • Query and Workload Analysis Statements
  • Help and Database Object Definition Tools
  • Some classifications of SQL group the data control language statements with the data definition language statements.

    Binding Style

    The ANSI/ISO SQL standards do not define the term binding style. The expression refers to a possible method by which an SQL statement can be invoked.

    Teradata Database supports the following SQL binding styles:

  • Direct, or interactive
  • Embedded SQL
  • Stored procedure
  • SQL Call Level Interface (as ODBC)
  • JDBC
  • The direct binding style is usually not qualified in this book set because it is the default style. Embedded SQL and stored procedure binding styles are always clearly specified, either explicitly or by context.

    Related Topics

    You can find more information on binding styles in the SQL book set and in other books.

     

    For more information on …

    See …

    embedded SQL

  • Teradata Preprocessor2 for Embedded SQL Programmer Guide
  • SQL Stored Procedures and Embedded SQL
  • stored procedures

    SQL Stored Procedures and Embedded SQL

    ODBC

    ODBC Driver for Teradata User Guide

    JDBC

    Teradata JDBC Driver User Guide