DB2 10.5 for Linux, UNIX, and Windows

DB2Connection.RetryParameterBindingOnError Property

Gets or sets the value indicating whether or not the provider will re-execute failed statements

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

Syntax

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

Property value

The default value will be true. Following the pattern of other boolean connection string keywords, RetryParameterBindingOnError will accept the values 1, true, and ON to set the property to True, and 0, false, and OFF to set the property to False

Remarks

Parameters that are bound with incorrect data types will result in an error. When the RetryParameterBindingOnError property is enabled, the IBM® Data Server Provider for .NET will attempt to bind the parameters again with data type returned from the implicit DESCRIBE statement and re-execute the statement. Enabling the RetryParameterBindingOnError property negatively impacts performance.