Versions 4 and later of DB2 includes outer join operators. Therefore, when you use the Query window and specify a left, right, or full join, Query and Reporting generates the WHERE or ON clause ...

Learn how to write a correlated subquery in DB2 and when it is useful for your data analysis. Compare, filter, or aggregate data from different tables or queries.

When an SQL query is compiled, a number of optimization techniques can be used to determine the most efficient access plan for that query. Using more optimization techniques results in: Optimization ...

The following section describes the DBMS-specific arguments that you use in the CONNECT statement. For more information about how to use the SQL Procedure Pass-Through Facility, see SQL Procedure Pass ...

Our work extends the use of materialized views for SQL/XML, and could be applied to XQuery. Within IBM DB2 9 (Viper), we implement query rewrite rules that enable the use of materialized views in the ...

SQL has emerged as an industry standard for querying relational database management systems, largely because a user need only specify what data is wanted, not the details of how to access that data. A ...