16.20 - Argument List - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

The arguments in the function call must appear as comma-separated expressions in the same order as the function declaration parameters.

The arguments in the function call must be compatible with the parameter declarations in the function definition of an existing function, and must fit into the compatible type without a possible loss of information. For example, a BYTEINT argument in a function call is compatible with an INTEGER parameter declaration in the function definition, and also fits into the INTEGER type without any loss of information.

To pass an argument that is not compatible with the corresponding parameter type, explicitly convert the argument to the proper type in the function call.