DB2®ConnectionStringBuilder.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(inIBM.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 defined with
an incorrect datatype will result in an error. Currently, this prompts
a try again step, wherein describe information is used to attempt
to determine the correct datatype for the parameter and the statement
is re-executed. Setting RetryParameterBindingOnError to true will
preserve this functionality. However, this process negatively impacts
performance, so it is recommended that it be set to false and
parameters be correctly defined