Gets or sets WHERE clause of the statement.
public virtual string Where {get; set;}
'Declaration
Public Overridable Property Where As String
Property Value
The WHERE clause of the statement.
The following example demonstrates how to use the
Where property.
DB2SelectStatement stmt = new DB2SelectStatement();
stmt.Columns.Add(new SelectColumn("ENAME"));
stmt.Tables.Add(new SelectTable("emp"));
stmt.Where = "1000 < SAL AND SAL < 1500 OR JOB = 'SALESMAN'";
DB2Command command = new DB2Command(stmt.ToString());
Dim stmt As New DB2SelectStatement
stmt.Columns.Add(New SelectColumn("ENAME"))
stmt.Tables.Add(New SelectTable("emp"))
stmt.Where = "1000 < SAL AND SAL < 1500 OR JOB = 'SALESMAN'"
Dim command As New DB2Command(stmt.ToString)