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

November 17, 2010 | Volume 9 Issue 22


TOP STORY: Format and Compile RPG to Use Embedded SQL
FEATURED ARTICLE: The API Corner: Removing Error Messages from the Job Log
NEWS HIGHLIGHT: 2010 iPulse Survey Results Reveal State of the IBM i Market and Top Independent Software Vendors
FORUM: Calculate Business Days Between Two Dates
BUYER'S GUIDE: WebSmart ILE and Barcode 400
Manage Subscription | Contact Us

Sponsor - T.L. Ashford & Associates
T.L. Ashford is “The Labeling Answer”® for the System i.

Ashford's Barcode400 has been the dependable choice for the industry since 1983. With Barcode400's newly enhanced Graphic Designer no “green screen” interaction is needed for label design. New features include: AFP/HP-compatible printing, easy-to-use graphics import tool, test print to desktop printer, simple font download tool, updated drivers and format listing reports. Even compliance labeling is made easy with design templates. Call 800-541-4893 to order your Fully-Functional, FREE Trial Software or visit us at T.L. Ashford & Associates. 

Also, be sure to download the new white paper: Bar Code / RFID Label Printing, Don't get caught in the integration trap.


Feature Article - Programming
Format and Compile RPG to Use Embedded SQL

Let's explore the nuts and bolts of using embedded SQL: file type, syntax, and compiling.

tom_snyderWritten by Tom Snyder

In a previous article, "Why Use Embedded SQL Within RPG?," I talked about why you would use embedded SQL in RPG. In this article, I will talk about how you could use embedded SQL within RPG. We'll start with an existing RPG program that is written with CHAIN and READ, and then we'll convert it to use embedded SQL.


Sponsor - Business Computer Design

Modernize Dated Green Screen Programs with BCD’s Presto You have a lot invested in your IBM i and in your green screen programs. Use BCD’s Presto to extract even more value from them:

Satisfy users with an instant Web GUI

Web enable ALL your IBM i screens

Add rich web components to your existing screens

No RPG, COBOL or DDS code changes. Start giving your

users the modern screens they want today!

Learn More, Watch a Video or Download a 30-day Trial



Feature Article - Programming
The API Corner: Removing Error Messages from the Job Log

Now that we've figured out how to receive them, how do we remove them if we want to?

bruce_viningWritten by Bruce Vining

Last month, in "The API Corner: More on Message Handling," we looked at how to receive diagnostic messages (such as CPF3213 – Members for file more than maximum allowed) using the Receive Program Message (QMHRCVPM) API. The diagnostic message was needed in order to determine the underlying cause of an escape message (in our example, CPF7306 – Member not added) and then take the appropriate corrective action. The recovery action for CPF3213 was to change the file's MAXMBRS attribute to *NOMAX by using the Change Physical File (CHGPF) command and then adding the required member using the Add Physical File Member (ADDPFM) command. Both of these commands were run by the RPG application program using the Process Commands (QCAPCMD) API. However, after successfully adding the member, we noticed that the job log still contained the CPF3213 diagnostic message along with the two completion messages (CPC7303 – File SOMEFILE in library xxxxxx changed and CPC7305 – Member yyyyyy added to file SOMEFILE in xxxxxx) that were related to our handling of the initial CPF7306 error. Today's "API Corner" article looks at various options of how we can, if we want to, remove these messages.


MC Showcase Buyer's Guide

Featured Products

WebSmart ILE lets you Modernize iSeries applications easier and has more integrated solutions to take you further! WebSmart is the easiest and most complete iSeries Web Application Development tool. WebSmart has everything you need to successfully develop new browser-based apps and modernize existing ones.

Whether you are part of a Fortune 100 or SMB organization, a one person shop or part of a larger team, you can immediately build new web applications or start transforming and modernizing legacy iSeries applications to real, professional-quality, database-driven Web applications. The PC based IDE is easy-to-learn, runs on HTTP Apache web server and does NOT need WebSphere. Create applications using Web Services, SOA, AJAX, XML, email, output to Excel, graphs. WebSmart offers these optional integrated solutions for complete modernization: • Clover Query • Free* Nexus Portal • Catapult • Free* RDW • SmartCharts (Free feature)


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