17.20 - Rules for Input and Output Arguments - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
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 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, see Teradata Vantage™ - SQL Stored Procedures and Embedded SQL, B035-1148.