Retrieving Values of Output Parameters - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
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.