parameter_style_specification - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

The parameter passing convention to be used when passing parameters to the procedure.

This clause is mandatory for all external procedures. The specified parameter style must match the parameter passing convention of the external procedure.

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 PROCEDURE or REPLACE PROCEDURE request.

SQL
Uses indicator variables to pass arguments.
As a result, you can always pass nulls as inputs and return nulls in results.
SQL is the default parameter style.
TD_GENERAL
Uses parameters to pass arguments.
Can neither be passed nor return nulls.
JAVA
Mandatory for all Java procedures.
If the Java procedure must accept null arguments, then the EXTERNAL NAME clause must include the list of parameters and specify data types that map to Java objects.