Rules for Input and Output Arguments

ODBC Driver for Teradata® User Guide

brand
Teradata Tools and Utilities
prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K
The following rules apply to the input and output arguments submitted with the SQL CALL statement in ODBC:
  • An IN or INOUT argument must be a question mark (? is used as an input placeholder) or value expression, with the following conditions:
Argument Condition
A value expression Must not contain colon-preceded identifiers. It must be a constant expression.

The value of the expression is treated as the input value for the corresponding parameter in the called stored procedure.

A NULL value expression can be used to initialize the corresponding parameter to NULL.

? The value for the corresponding IN or INOUT parameter of the called procedure must be set using ODBC-specific calls prior to calling the stored procedure.
  • An OUT argument must be an OUT call placeholder or a “?” character. A placeholder can consist of a Teradata data definition and the Teradata Database-supported FORMAT, TITLE, and NAMED phrases. If the argument is a “?” character, the value for the corresponding OUT parameter of the called procedure must be set using ODBC-specific calls prior to calling the stored procedure.

For the other rules and details governing the CALL statement and usage of stored procedure parameters, refer to SQL Stored Procedures and Embedded SQL (B035-1148).