Retrieving Values of Output Parameters - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
fbo1512081269404.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

The output values of INOUT and OUT parameters are returned after completion of the CALL statement in the following forms:

CALL is Issued from this Type of Application Output Parameter Values
BTEQ Result row.
CLIv2

The values for all the INOUT and OUT parameters are returned in one row, irrespective of the number of parameters.

The value of each parameter is a field in the output.

Embedded SQL Stored in the corresponding host variable.
Another procedure stored in the corresponding local variable or parameter of the calling procedure.
ODBC To be retrieved using an ODBC API.
JDBC To be retrieved using a JDBC API.