DSN Option to Return Output Parameters as ResultSet - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
smj1488824663219.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

By default, the INOUT and OUT parameter values are updated after a stored procedure call with the ODBC driver. The OutputAsResultSet keyword is currently available to enable returning the INOUT and OUT parameters as a result set.

This feature was originally designed for earlier versions of ODBC, and will be deprecated in a future release. The ODBC specification does not have an option for returning these parameters as a result set — they are always returned through the parameters.

It is strongly advised to retain the default OutputAsResultSet setting of no for best compliance with the ODBC specification, and to prepare for the removal of this option in a future release.

For a code sample and additional information, see Stored Procedures Dynamic Result Sets.