MAGAZINES

MC Press Resource Centers
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

October 5, 2011 | Volume 10 Issue 19

ISSUE HIGHLIGHTS

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

Sponsor - CNX Corporation
 

Dazzle your IBM i users!

Valence combines state-of-the-art browser components with your favorite business language (RPG) to produce World Class Web 2.0 apps on IBM i.

Learn industry-standard techniques for developing true Web 2.0 applications with popular UI features such as grids, forms, trees, charts, graphs and much, much more!

Now available: Valence Version 3.0 - includes mobile device support, the Valence Nitro integrated source editor and numerous other features. Download the Community Developer Edition for free!


Read More >>

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.


Read More >>

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.


Read More >>


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.


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