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

February 16, 2011 | Volume 10 Issue 4


TOP STORY: An Open-Source DB2 SQL Graphical Tool That You Can Use for All Your Databases
FEATURED ARTICLE: Create an MD5 Hash Using RPG and SQL
NEWS HIGHLIGHT: IBM and WAC to Streamline Creation of Mobile Application Stores
FORUM: Too Many Objects in One Library!
TRIAL SOFTWARE: Free unlimited trial of the Valence Web Application Framework for System i
Manage Subscription | Contact Us

Sponsor - Vision Solutions, Inc.
Power7 Webcast! Please join us On-Demand for Benefits of Migrating Now to Power7 presented by IBM i Power Systems marketing manager, Guy Paradise and Vision Solutions Services vice president, Peter Sa. In addition to learning about the significant IT and business benefits of migrating now to Power7, you will gain insight on how to smoothly make the upgrade without sacrificing your weekends, incurring data loss or business disruption.

Watch this important webcast today!


Feature Article - Programming
An Open-Source DB2 SQL Graphical Tool That You Can Use for All Your Databases

Install SQuirreL SQL client to run interactive SQL on your IBM i.

tom_snyderWritten by Tom Snyder

As you start using embedded SQL more frequently within your RPG code, you'll soon find that your SQL statements are becoming larger and larger and the interactive SQL tool on the green-screen starts becoming quite cumbersome. In this article, I will introduce Squirrel SQL, which is an open-source SQL client that gives you not only a better interface to your DB2 database, but also access to numerous other databases.


Sponsor - The RPG & DB2 Summit

Upgrade your skills — and discover new ways to leverage the amazing IBM i — at the next RPG & DB2 Summit. Learn practical, use-it-today tips and techniques and get 1-on-1 advice from top experts Paul Tuohy, Susan Gantner, Jon Paris, Skip Marchesani, Scott Klement and others in a highly interactive, invigorating, fun environment. Hear the latest on RPG IV, DB2, embedded SQL, RPG & the Web, PHP, RDi, SQL tuning & more. Register by Feb 18 for just $1095 – save $300! Click to see the preliminary Session Grid.



Feature Article - Programming
Create an MD5 Hash Using RPG and SQL

Using an MD5 hash offers potential integration, performance, and security benefits.

Written by Michael Sansoterra

When developing modern applications or enhancing legacy ones, an RPG or DB2 routine may need to apply an MD5 hash to application data. Fortunately, IBM i/OS offers a machine interface operation called CIPHER to make the task of implementing MD5 relatively simple.


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor