Retrieving Values of Output Parameters - Advanced SQL Engine - Teradata Database

SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
vjt1596846980081.ditamap
dita:ditavalPath
vjt1596846980081.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.