dotConnect for DB2 Documentation
Devart.Data.DB2 Namespace / DB2SelectStatement Class
Members Example

DB2SelectStatement Class
Represents DB2 SELECT statement.
Syntax
'Declaration
 
Public NotInheritable Class DB2SelectStatement 
   Inherits Devart.Common.SelectStatement
 
Remarks
Use DB2SelectStatement to construct a SELECT statement in run time. The DB2SelectStatement provides an object-oriented interface for manipulating each part of SQL SELECT statements. Use the ToString method to retrieve text of the constructed statement.
Example
The following example demonstrates how to use the DB2SelectStatement class.
DB2SelectStatement stmt = new DB2SelectStatement();

stmt.Columns.Add(new SelectColumn("test", "td", "dname", "Department"));
stmt.Columns.Add(new SelectColumn("", "td", "loc", "Location"));
stmt.Columns.Add(new SelectColumn("", "te", "ename", "Name"));

stmt.Tables.Add(new SelectTable("test", "dept", "td"));
stmt.Tables.Add(new SelectTable("", "emp", "te"));

stmt.GroupBy.Add(new SelectColumn("", "te", "empno", ""));
stmt.OrderBy.Add(new SelectColumn("", "te", "ename", ""));
Dim stmt As New DB2SelectStatement

stmt.Columns.Add(New SelectColumn("test", "td", "dname", "Department"))
stmt.Columns.Add(New SelectColumn("", "td", "loc", "Location"))
stmt.Columns.Add(New SelectColumn("", "te", "ename", "Name"))

stmt.Tables.Add(New SelectTable("test", "dept", "td"))
stmt.Tables.Add(New SelectTable("", "emp", "te"))

stmt.GroupBy.Add(New SelectColumn("", "te", "empno", ""))
stmt.OrderBy.Add(New SelectColumn("", "te", "ename", ""))
Inheritance Hierarchy

System.Object
   Devart.Common.SelectStatement
      Devart.Data.DB2.DB2SelectStatement

See Also