MAGAZINES

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

March 12, 2010 | Volume 7 Issue 10

ISSUE HIGHLIGHTS

TOP STORY: TechTip: Members Only? No Problem with DB2 Web Query
FEATURED ARTICLE: Crossroads Virtual Tape Appliance to Wed Help/Systems' Robot/SAVE
MORE NEWS: New IBM Software and Services to Help Customers Exploit Existing Assets
WHITE PAPER: Business Intelligence on the IBM i: Finding Your Way
FORUM: VARLEN in DDS vs. VARCHAR in DDL
BLOG: System i Management Tips

Manage Subscription | Contact Us

Feature Article - TechTip
 
TechTip: Members Only? No Problem with DB2 Web Query

Access your multi-member files, let your users dynamically select the member they want to query at run time, and create a report that uses the latest and greatest database engine technology.

gene_cobbWritten by Gene Cobb

Over the last several years, I have written several articles about DB2 for i and DB2 Web Query, some of which emphasized the importance of employing techniques to ensure that your queries are using the SQL Query Engine (SQE), the strategic database engine for DB2 for i. One of the requirements for SQE processing is that the database access method must be SQL. However, one of the very few drawbacks with SQL access on our beloved system is that it does not natively support the concept of physical file members.


Read More >>

Feature Article - Analysis
 
Crossroads Virtual Tape Appliance to Wed Help/Systems' Robot/SAVE

Tape may be everyone's darling, but SPHiNX is a dandy earning new friends daily.

chris_smithWritten by Chris Smith

I recently wrote an article titled "Bulletin: Tape Is Alive and Well at IBM." It was about several new technologies that will effectively extend the life of tape as a viable backup solution for a decade or longer. However, the whole time I was writing it, I was thinking, "Wow, this is amazing! I thought tape was on the way out long ago!"

 

That, of course, is a naïve belief. The fact is that almost every company uses tape in one capacity or another for backup or archiving even if they have a more robust backup solution running in parallel.


Read More >>

In the News

Read More >>
Support MC Press - Visit Our Sponsors

Forums Sponsor

POPULAR FORUMS

Forums

 Search Sponsor

 

POPULAR SEARCHES

Search


Read More >>
   MC-STORE.COM