Rules for Input and Output Arguments - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities
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).