DB2®Command.StatementConcentrator Property

Gets or sets the value determining whether or not to enable statement concentrator literals.

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

Syntax


[Visual Basic]
Public Property StatementConcentrator As string
[C#]
public string StatementConcentrator {get; set;}
[C++]
public: __property string* get_StatementConcentrator();
public: __property void set_StatementConcentrator(string*);
[JScript]
public function get StatementConcentrator() : string;
public function set StatementConcentrator(string);

Property value

A string representing whether or not statement concentrator literals are enabled.

Set the property to:
  • Off - statement concentrator literals are disabled.
  • Literals - statement concentrator literals are enabled. Literals will be converted to parameters.

Remarks

If this property is not set for the command then the default behavior for statement concentrator literals will be determined by the connection string properties or the server-side configuration.

The value returned by this property reflects the StatementConcentrator value set through the connection string keyword or explicitly set for this property. While this StatementConcentrator property has not been explicitly set, the property value can be changed by either setting the connection string property or by explicitly setting this property. If a StatementConcentrator value has not been specified by either this property or the connection string, the property will return NULL.

Once this property has been explicitly set it cannot be changed by the connection string property or be reset to NULL. This DB2Command property will override the connection string property.