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 21, 2009 | Vol 8 Issue 20


In This Issue:

Sponsor - Business Computer Design
WebSmart PHP or WebSmart ILE create new Web Apps in 5 minutes! Templates & Wizards step you along every step of the way and you get to reuse RPG or COBOL code. Access data from any platform. BCD tools let you modernize professionally & with our 15% Promo, even more affordably. Plus we include the BEST vendor support you've ever experienced. Click To: Learn more, Request a White Paper, Schedule a Web Demo or get a FREE Trial!


Feature Article - Programming
Practical SQL: Don't Be Afraid of Recursion

A word that sometimes strikes fear into the programmers, "recursion" is sometimes the only tool for the job, and this article shows you how to recurse in SQL.

joe_plutaWritten by Joe Pluta

Today's article is very simple and straightforward. I'm going to present you with one of the more complex basic SQL statements you'll run across and then break it down piece by piece. I know that the "complex basic" seems somewhat paradoxical, but it's not. The SQL statement I'll be showing you is basic because it has no frills; pretty much everything in the statement is needed to do what we need to do. At the same time, the statement is complex because even at its minimum the statement requires a lot of moving parts. Fear not, gentle reader, I shall act as your guide through this dangerous territory, and at the end, you'll have yet one more powerful weapon in your programming arsenal.


Sponsor - Arcad Software, Inc.
Experience a New Dimension in Change Management

If your current CM can’t handle ILE, SQL, .net, or multi-platform deployment…

If you need to manage critical data changes…

If your maintenance costs are way up, and you are getting less in return…

We can help.  Let us show you how ARCAD’s advanced solutions, active R&D team, and responsive customer support will give you new capabilities and ongoing ROI.

Call for a Web demo today! 800-676-4709   ARCAD Software   Ask about our migration specials


Feature Article - Programming
The API Corner: Intercepting Inquiry Messages

Learn how to write an inquiry-handling exit program.

bruce_viningWritten by Bruce Vining

This is the third in a series of articles related to inquiry messages. The first two articles, "Beyond Watches" and "Validating Inquiry Message Responses," introduced the use of the reply-handling exit point QIBM_QMH_REPLY_INQ. With this exit point, you are able to validate the reply and, if you want, change the reply after the end user responds to an inquiry message. The current article introduces another exit point in the system. This exit point, QIBM_QMH_HDL_INQEXT, allows you to intercept an inquiry message before the end user is involved. That is, your exit program can directly provide the appropriate response without any operator involvement.


MC Showcase Buyer's Guide

Featured Products

WebSmart Presto
They won’t believe these are your System i Applications.
Instantly Web Enable your System i 5250 RPG & Cobol apps and Menus with No code changes.
Presto runs straight out of the box. In less than a day all of your 5250 screens will dynamically be presented as web pages with zero 5250 OLTP(batch use).
Keep your system i relevant in the eyes of your users, customers and upper management. The fastest way to do this is to use Presto. Your users get browser based access to existing RPG or Cobol applications and menus in a modern look that is easier for users to navigate.

Learn more about Business Computer Design Int'l, Inc. and its products here.


T.L. Ashford's award winning BARCODE400 software is the labeling answer for the iSeries. With this versatile and easy to use software you will be designing and printing labels in minutes. Compliance labeling is a snap using templates provide by TL Ashford.

Learn more about T.L. Ashford & Associates and its Barcode and RFID solutions here.


Want to feature your company products? Click here or call (208) 726-6822 for information.


In the News


Support MC Press - Visit Our Sponsors


Forums Sponsor





Search Sponsor