CALL Examples | SQL Statements | Teradata Vantage - 17.05 - Example: Input Arguments in BTEQ and CLIv2 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

Consider the following stored procedure spSample1 that has three IN parameters, p1, p2, and p3 of INTEGER data type. The argument list can be specified in either of the following formats:

     CALL spSample1 (1, 2, 3);

     CALL spSample1(1, CAST(((2 + 4) * 2) AS FORMAT 'ZZZ9'), 3);

The rule of specifying the arguments as a positional list applies to all arguments (IN, INOUT, or OUT).