15.10 - PARAMETER STYLE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

The parameter passing convention to be used when passing parameters to the table function.

The specified parameter style must match the parameter passing convention of the external function.

This clause is optional for SQL table functions and can only be specified once per function definition. It is mandatory for Java table functions.

If you do not specify a parameter style at this point, you can specify one with the external body reference.

You cannot specify parameter styles more than once in the same CREATE/REPLACE FUNCTION request.

You cannot use a table function to enforce row-level security for a security constraint.

For more information about UDF parameter styles, see “CREATE FUNCTION (Table Form)” in SQL Data Definition Language - Detailed Topics, B035-1184.

SQL
Uses indicator variables to pass arguments.
As a result, you can always pass nulls as iinputs and return them in results.
SQL is the default parameter style.
JAVA
Mandatory for all Java table functions.
If the Java function must accept null arguments, then the EXTERNAL NAME clause must include the list of parameters and specify data types that map to Java objects.
SQLTABLE
Indicates the function is a table operator and is supported by all external languages. SQLTABLE models the input and output data as a row iterator over a collection of rows. A function defined with this parameter style can only accept TABLE as an input parameter type. For more information, see “Table Operators” in Chapter 1 C/C++ User-Defined Functions and Chapter 4 Java User-Defined Functions of SQL External Routine Programming.