MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

October 8, 2008 | Vol 3 Issue 19


In This Issue:

Feature Article - Database
Employ Best Practices When Integrating Disparate Data

Disparate data can inhibit value creation, but data integration best practices allow organizations to fully leverage the inherent value in their information resources.

john_gay.jpgBy John Gay

Silos of disparate data plague many companies. The reasons for the data diversity vary: organizations may run best-of-breed applications on the most appropriate platform for each product; in the days of client/server computing, the responsibility for choosing applications may have been decentralized, with different departments choosing different platforms; a merged company may use a variety of different applications, keeping separate some of the formerly individual companies' activities and the software that supports those parallel activities, while choosing the best of the predecessor companies' applications to serve those business functions that are merged. And the list goes on.


Feature Article - Programming
Exploit the Power of Joins in SQL SELECT Statements

Inner joins, outer joins, exception joins, cross joins... Do you know how to take full advantage of all the types of joins?

kevin_forsythe.jpgBy Kevin Forsythe

Editor's Note: In this excerpt from SQL for eServer i5 and iSeries, author Kevin Forsythe explains how to use the various joins available in SQL.


In SQL, the basic SELECT statement displays one or more columns from a single file. When columns must be merged from two or more files, a join should be used. There are two ways to accomplish this. A join can be written either with or without the JOIN keyword. Creating simple joins is easy enough, but as they get more complex, using the JOIN keyword becomes more attractive.  


Support MC Press - Visit Our Sponsors
iAD 10-08-2008

Forums Sponsor

 Popular Forums




Search Sponsor


 Popular Searches