Querying a Data Grid Table

Application programs have two options available for querying the data in the data grid:
  • Table iterator
  • Session statement
A table iterator is useful for basic queries on a table where all of the columns of a table are expected in each row of the query results.

A Session statement is used to execute SQL SELECT statements. Therefore, you have more control over the columns in the query results and also on whether the results must be aggregated or sorted. Using the statement, you can optionally set parameters in a WHERE clause as opposed to specifying an entire string for the filter in a table iterator.

Related concepts
Related tasks