SQL Functional Families and Binding Styles | SQL Fundamentals | Teradata Vantage - 17.10 - SQL Functional Families and Binding Styles - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Fundamentals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1141-171K
Language
English (United States)

The SQL language can be characterized in several different ways. This section 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.

The 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 document set because it is the default style. Embedded SQL and stored procedure binding styles are always clearly specified, either explicitly or by context.

Related Information

For more information about:
  • Embedded SQL, see Teradata® Preprocessor2 for Embedded SQL Programmer Guide, B035-2446 or Teradata Vantage™ - SQL Stored Procedures and Embedded SQL, B035-1148.
  • Stored procedures, see Teradata Vantage™ - SQL Stored Procedures and Embedded SQL, B035-1148.
  • ODBC, see ODBC Driver for Teradata® User Guide, B035-2526.
  • JDBC, see Teradata JDBC Driver Reference, available at https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/frameset.html.