DB2 10.5 for Linux, UNIX, and Windows

DB2Connection.ResultSetAsReturnValue Property

Set this value to retrieve result sets from Informix® user-defined routines (UDR) as a ReturnValue parameter. This property is ignored when a ReturnValue parameter is not bound in the parameter collection.

Namespace:: IBM.Data.DB2
Assembly:: IBM.Data.DB2 (in IBM.Data.DB2.dll)

Syntax

[Visual Basic]
Public Property ResultSetAsReturnValue As Boolean
[C#]
public bool ResultSetAsReturnValue {get; set;}
[C++]
public: __property bool get_ResultSetAsReturnValue();
public: __property void set_ResultSetAsReturnValue(bool);
[JScript]
public function get ResultSetAsReturnValue() : Boolean;
public function set ResultSetAsReturnValue(Boolean);

Property value

Set to true to work with Informix UDRs that return result sets. Otherwise, set to false. The default value is false.

Exceptions

Exception type	Condition
ArguementException	Used on an unsupported server.

Remarks

If this property is set, and theUDR returns multiple types or multiple rows, the ReturnValue parameter contains the value of the first row and first column. Other values are ignored.

This property does not affect DB2Connection.DeriveParameters(). Applications should specify the correct type for the ReturnValue parameter. If the type does not match the ReturnValue parameter, an exception is generated.