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

ODBC Driver for Teradata User Guide

prodname
ODBC Driver for Teradata
vrm_release
15.10
category
User Guide
featnum
B035-2509-035K

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” on page 112.