Filter by products, topics, and types of content

(110 Products)

(142 Topics)

(12 Industries)

(14 Types)

1 - 12 of 12 results
Show Summaries | Hide Summaries
View Results
Title none Type none Date none
Meet the experts: Terry Purcell on coding predicates in outer joins: Advanced outer join constructs
In this second of two parts, Terry Purcell, an IBM Gold Consultant with Yevich, Lawson, and Associates, and the the winner of the Best Overall Speaker Award at the 2001 IDUG Asia Pacific conference in Canberra, Australia, offers more advice on coding predicates in outer joins.
Articles 17 Jan 2002
Meet the experts: Terry Purcell on coding predicates in outer joins: A comparison of simple outer join constructs
In this first of two parts, Terry Purcell, an IBM Gold Consultant with Yevich, Lawson, and Associates, and the the winner of the Best Overall Speaker Award at the 2001 IDUG Asia Pacific conference in Canberra, Australia, offers advice on coding predicates in outer joins.
Articles 04 Dec 2001
Ask the Experts: Terry Purcell on Outer Joins
Terry Purcell answers a question from a reader about using large tables with outer joins.
Articles 15 Jul 2002
No more joins: An overview of Graph database query languages Alaa Mahmoud
Once you have your mind set on a particular graph database, the next question will be, "Which query language should I use?" Unlike SQL databases where you pretty much have only one choice, graph databases have numerous query languages, each of which is trying to solve a particular problem.
Blog 21 Feb 2017
Using dynamic Open SQL to perform joins on SAP transparent tables
This article gives an end-to-end example of how an Open SQL query that handles arbitrary JOINS between SAP tables that are not known during coding time can be executed dynamically. You will learn how joins are done in Open SQL, how to specify the needed clauses of this statement during runtime, and how to dynamically create the target structure that is needed with the help of the RTTS (Run Time Type Services) API of ABAP. Specifying Open SQL conditions with joins during execution time has many applications, including when the queries are only known during runtime. Data extraction and data browsing of the SAP system are examples. In another example, specifying queries dynamically helps if the main application logic is not implemented in ABAP code but in a remote program. In this case, this article describes how only a small generic ABAP program is needed, and the SQL queries can be maintained externally.
Also available in: Chinese  
Articles 15 Jul 2010
Getting the Most from Hash Joins on DB2 Universal Database
Hash joins can significantly improve the performance of certain queries when the system is tuned properly. This paper explains how hash join works and how to properly tune your system to be able to exploit its potential.
Articles 11 Jul 2005
Work with IBM DB2 UDB databases and SQL in Delphi for .NET
This article, a follow-up to the SQL DDL article, "Using Delphi code to create/drop DB2 UDB database tables," focuses on the use of SQL queries to build simple and more complex SQL SELECT queries to end up with master-detail relations. The author also examines SQL joins in detail, covering examples of inner joins, left/right outer joins, and the differences between these joins.
Articles 30 Sep 2004
Offloading your Informix data in Spark, Part 3: Complex analysis
The third part of this tutorial series goes deeper into joins and more complex queries. Learn how to get data from your Informix database and dump it in Spark so you can leverage it against other data sources and compile advanced analytics all that in Java. The targeted audience is Informix and non-Informix users seeking to bring RDBMS data into Spark.
Articles 20 Sep 2017
Tuning DB2 SQL Access Paths
Database guru Craig Mullins explains the basics of access paths and join methods, and then shows you how tools such as Explain to monitor and tune your SQL performance.
Also available in: Japanese  
Articles 23 Jan 2003
Informix DBA: More Musings on Informix 11.7
Lester Knutsen and Art Kagel evaluate some of the advanced capabilities that come with Informix 11.7.
Articles 14 Feb 2011
IBM Cognos Proven Practices: Performance Tips when using Cross JoinQueries against a TM1 Datasource
The purpose of this document is to provide performance guidance when querying large datasets from a TM1 Datasource.
Also available in: Chinese  
Articles 19 Nov 2012
The Federation: Database Interoperability (Part 1)
Popular author and presenter Marty Lurie tackles the federation - the data federation, that is. Marty explains how IBM federated database technology works, the critical technical success factors, and how the IBM implementation stacks up when tested against these factors.
Articles 24 Apr 2003
1 - 12 of 12 results
Show Summaries | Hide Summaries