15.00 - Optional Function Characteristics - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

Optional Function Characteristics

The following set of clauses is optional. You can specify all or none of them, and in any order, but each clause defaults to a particular value if it is not specified.

  • Specific function name (see “Specific Function Name Clause” on page 269)
  • Function class (see “Function Class Clause” on page 269)
  • Parameter style (see “Parameter Style Clause” on page 271)
  • Deterministic characteristics (see “Deterministic Characteristics Clause” on page 272)
  • Null call (see “Null Call Clause” on page 272)
  • External data access (see “External Data Access Clause” on page 274)
  • If you specify any of these clauses, you must specify them sequentially prior to specifying the External Clause (see “EXTERNAL NAME Clause” on page 276), which can be followed by a Parameter Style Clause see “Parameter Style Clause” on page 271).