This section details the technology's data handling
capacities.
Select The
technology's capacity to construct a data array resulting from a query.
Where The
technology's capacity to filter this array according to conditions.
Join Support The
technology's capacity to join several data arrays (two-dimensional data sets)
into one only. This capacity can take several forms:
1. If no
check box is selected, the technology does not support joins.
2. If only
Ordered is selected, the technology support joins in the ANSI-SQL syntax. These
joins are specified in the FROM clause, as in the example below.
For example: FROM emp LEFT JOIN
dept ON (emp.deptno = dept.deptno) .
3. If only
Not Ordered is selected, the technology supports joins in a non-ordered syntax.
These joins are typically specified in the WHERE clauses with an
technology-specific join operator, as in the following example for Oracle
Database: WHERE emp.deptno (+) = dept.deptno
4. If both
Ordered and Not Ordered are selected, the technology supports both ordered and
non-ordered joins. Usually, technologies supporting both syntaxes do not allow
mixing them within the same statement.
5. To
enable the Mixed syntax allowed option, select both Ordered and Not Ordered. If
Mixed syntax allowed is selected, the technology supports mixing ordered and
non-ordered joins within the same statement.
Partitioning Support The
technology's capacity to support partitioning.
No: The technology does not support
partitioning.
Partitions: The technology supports
partitions in SELECT statements.
SubPartitions: The technology supports
partitions and subpartitions in SELECT statements.
Support SELECT lookup The
technology's capacity to support lookup as a SELECT statement in a SELECT
clause.
Support Derived Table The
technology's capacity to support a SELECT statement in a FROM clause.
Support Set Operator The
technology's capacity to support set-based operators.
Comma-separated Operator List, lists the operators supported
by the given technology. For example, for Oracle:
UNION, UNION ALL, MINUS, INTERSECT 
No comments:
Post a Comment