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 7, 2012 | Volume 11 Issue 5

ISSUE HIGHLIGHTS

TOP STORY: Practical SQL: Using Old World Tools with New World Data
FEATURED ARTICLE: The Case for SQL CASE
NEWS HIGHLIGHT: Halcyon Spooled File Manager V9.0 for IBM i Includes Major Enhancements
FORUM: Zip and Unzip for Free!
TRIAL SOFTWARE: Free unlimited trial of the Valence Web Application Framework for IBM i
EVENT: RPG & DB2 Summit
Manage Subscription | Contact Us

Feature Article - Programming
 
Practical SQL: Using Old World Tools with New World Data

Using DDL to define your files provides a wealth of new features, but just which features should you embrace? Some of that depends on the tools you use, and this article explains a couple of pitfalls.

joe_plutaWritten by Joe Pluta

The ongoing SQL vs. native I/O debate really consists of two different debates: how to define your data and how to access it. Access is either via native I/O or SQL, but that's not the topic today. Today, I'm focused on the data definition debate, either the older Data Definition Specifications (DDS) or the more modern SQL-based Data Definition Language (DDL). I firmly believe this dispute has been decided in favor of DDL, but DDL is not perfect. Some potential pitfalls exist, and this article will address one of the more onerous problems.


Read More >>

Feature Article - Programming
 
The Case for SQL CASE

SQL CASE expressions are powerful. Understand their syntax and where they can be used.

sam_lennonWritten by Sam Lennon

Did you know that the SQL CASE construct can be used in SQL SELECT and UPDATE statements and in WHERE, GROUP BY, and ORDER BY clauses? This tip explains SQL CASE through examples that you can run and experiment with. It also gives an overview of SQL CASE syntax, though it does not attempt to rewrite the IBM DB2 for i SQL Reference manual.


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