17.10 - Parameter Passing Convention - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

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

External stored procedures support two types of parameter passing conventions.

Parameter Passing Convention Description
Parameter Style SQL Provides a way to pass nulls as IN or INOUT arguments and return nulls as INOUT or OUT arguments.
Parameter Style TD_GENERAL Does not accept null IN or INOUT arguments and does not return null INOUT or OUT arguments.

The parameter passing convention you use to code an external stored procedure must correspond to the parameter passing specification in the CREATE PROCEDURE statement for the external stored procedure.

IF CREATE PROCEDURE specifies … THEN use the following syntax for the function parameter list …
PARAMETER STYLE SQL or omits the PARAMETER STYLE option Syntax for Parameter Style SQL.
PARAMETER STYLE TD_GENERAL Syntax for Parameter Style TD_GENERAL.