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 5, 2011 | Volume 10 Issue 19


TOP STORY: Practical SQL: Three Ways to JOIN
FEATURED ARTICLE: Book Review: Subfiles in Free-Format RPG
ADVERTORIAL: RPG Display Modernization Gets Wings
NEWS HIGHLIGHT: Symtrax Releases StarQuery 4.0, a Multi-database, Multi-dimensional Business Intelligence Solution
FORUM: Mix Alphanumeric and DBCS-Open Type Fields in a File
TRIAL SOFTWARE: Free unlimited trial of the Valence Web Application Framework for IBM i
Manage Subscription | Contact Us

Feature Article - Programming
Practical SQL: Three Ways to JOIN

JOINing tables is one of the fundamental tasks in SQL, and this article explains three basic syntactical approaches.

joe_plutaWritten by Joe Pluta

SQL is the tool of choice for querying relational data, and the whole idea behind relational data is that the tables are related. What this means is that a common field in two tables can be used to tie rows from each table together into a coherent set of data. In SQL, this is performed via the JOIN, which has three distinct syntactical variations. This article will explain the differences, including a recent change that might catch you unaware.


Feature Article - Programming
Book Review: Subfiles in Free-Format RPG

Whether you're a newbie or a seasoned pro, this book has something for you.

mike_faustWritten by Mike Faust

For System i developers, mastering the ability to develop subfile applications is an absolute must! In Subfiles in Free-Format RPG, Kevin Vandever takes the reader through the subfile concept—from start to finish. Unlike other books on the topic, this one specifically focuses on coding subfile applications in free-format RPG and does an excellent job of explaining how to use subfiles in the modern rendition of the RPG language.


Advertorial - ASNA
RPG Display Modernization Gets Wings

Convert old 5250 screens to modern GUI formats in a few easy steps.

tom_stockwellWritten by Thomas M. Stockwell

Last year, ASNA introduced its ASNA Wings modernization tool, which quickly and efficiently converts the old 5250 green-screen legacy display files into .NET ASPX Web forms. ASNA Wings has been out for a year now, so I made use of an opportunity to take a look at the product under the guidance of Anne Ferguson and Roger Pence. Ferguson is ASNA's co-founder and president, and Pence is ASNA's U.S. customer service and education director.


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor