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

April 3, 2013 | Volume 12 Issue 7

ISSUE HIGHLIGHTS

TOP STORY: Practical SQL: OLAP, Part 1
FEATURED ARTICLE: Be Kind to Your DBCS Data
NEWS HIGHLIGHT: Help/Systems Gains New Data Warehouse Management Capability with IBM ShowCase Software Acquisition
BUYER'S GUIDE: DBXFlex Report Writer / Query Tool
EVENT: Interactive Workstation Programming in RPG IV

Feature Article - Programming
 
Practical SQL: OLAP, Part 1

Online Analytical Processing (OLAP) adds a variety of processing features to SQL syntax that makes it much more useful as an ad hoc analysis tool, and this article introduces the first of those functions.

joe plutaWritten by Joe Pluta

SQL has always been a great tool for querying data. The problem is that SQL doesn't always lend itself to the sort of pattern analysis that's needed in enterprise data processing. Something goes awry in the database and the only way to identify the source of the problem is to backtrack through history. Let me give you a real-world example (the data has been changed to protect the innocent, but the situation is pretty common).


Read More >>

Feature Article - Programming
 
Be Kind to Your DBCS Data

Learn how to ensure the validity of extended character string assignment via the CPYECLAP instruction.

junlei liWritten by Junlei Li

IMHO, high-level languages (HLLs) in IBM i do not treat character strings containing double-byte character set (DBCS) characters seriously enough. For example, assigning a long character string containing DBCS characters to a shorter character variable using the EVAL operation code of RPG would probably truncate the DBCS data in the source string and therefore lead to an invalid result character string.


Read More >>

In the News

Read More >>
Support MC Press - Visit Our Sponsors

Forums Sponsor

POPULAR FORUMS

Forums

Search Sponsor

POPULAR SEARCHES

Search

  Bookstore Sidebar Header

 

 

 


Read More >>
   MC-STORE.COM