- 78. TechTip: Creating Local OLAP Cube Data Files with DB2 Data
- (DB2)
- ... & _ " FROM Northwind.OrderDetails OD " & _ "INNER JOIN Northwind.Orders OH ON OH.OrderID=OD.OrderID " & _ "INNER JOIN Northwind.Products PD ON PD.ProductID=OD.ProductID ...
- Created on 23 October 2008
- 79. Making the Best Use of V6 SQL OLAP Functions
- (SQL)
- ... classes (Figure 9). This makes sense, given there are no local selection predicates for any of the tables. The inner join order is students, then activities and students, and then classes. To accomplish ...
- Created on 21 October 2008
- 80. IBM and ISVs Promise Accelerated Software Delivery
- (Development Tools / Utilities)
- ... In related Rational Software news, IBM announced winners of the inaugural Rational Awards recognizing business partners for delivering outstanding value to clients and innovative approaches to solving ...
- Created on 08 June 2008
- 81. IT Companies Shell Out for Charity as PGA Golf Tourney Opens in L.A.
- (Channel News)
- ... forces this week to help fight inner-city poverty by sponsoring a viewing and reception area at the L.A. Open PGA Champions golf tourney. The sponsors are IBM Tivoli and IBM Business Partners AVNET, Azaleos, ...
- Created on 14 February 2008
- 82. RPG and DB2 Will Sizzle at the Summit in Orlando
- (RPG)
- ... other, and to avoid the hassles of doing your meals on your own, we host a welcome reception and dinner on the first evening, and also continental breakfast, lunch, and break refreshments for each of the ...
- Created on 04 December 2007
- 83. SQL Subselect: Soup to Nuts
- (SQL)
- ... In this example, it is called the primary or outer SELECT: SELECT nbr, nam, sal, dpt, FROM emp The second SELECT statement is the subselect (also called the inner SELECT): (SELECT dpt FROM dep WHERE dnm LIKE 'S%') ...
- Created on 06 November 2007
- 84. Book Review: DB2 9 Fundamentals
- (DB2)
- ... As a software engineer frequently working with database-related technology, chapters 5 and 6 are my personal favorites of the book. Sanders not only covers beginner's SQL syntax (CRUD statements, ...
- Created on 23 October 2007