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

May 4 | Volume 10 Issue 9


TOP STORY: Practical SQL: Calling RPG from SQL, Part II
FEATURED ARTICLE: When CCSID Constants Vary, Part I
NEWS HIGHLIGHT: Maxava Debuts Maxava HA Enterprise Plus at COMMON 
FORUM: Help! CODE/400 Error!
INDUSTRY WATCH BLOG: MC Press Online's Continuing Coverage of COMMON 2011
Manage Subscription | Contact Us

Sponsor - T.L. Ashford & Associates
Barcode400 Labeling Software makes it easy for IBM i users to design and print labels in minutes.

T.L. Ashford has over 28 years of experience in software development and backs that commitment with a highly qualified technical support team.

You can count on T.L. Ashford for your bar code, compliance and RFID labeling needs. Call 800-541-4893 to see what Barcode400 Software can do for you or use the Live Chat feature at


Feature Article - Programming
Practical SQL: Calling RPG from SQL, Part II

This second article on combining the strengths of RPG and SQL shows how to turn a stored procedure into a user-defined function (UDF).

joe_plutaWritten by Joe Pluta

In my previous article, I showed you how to create a stored procedure that will invoke an RPG program (or COBOL or CL or any other program, ILE or non-ILE). I also showed you how to test it and even explained the primary shortcoming of stored procedures: they can't be used in SELECT statements. I explained that in order to use external business logic inside of a SELECT statement, you need to use the other SQL extension technique, the user-defined function (UDF). This article shows how to create a UDF that uses your stored procedure.


Feature Article - Programming
When CCSID Constants Vary, Part I

Learn how one simple character can make a program go crazy.

jean-paul_lamontreWritten by Jean-Paul Lamontre

Several years ago, I wrote an email processing program for the System i and posted the source on my Web site. Several people have downloaded the code, compiled the program, and run it without any problems…until recently. For a few months now, people have been reporting that the program crashes. The program MAIL, which worked perfectly for several years, suddenly went haywire.


MC Industry Watch Blog

News from COMMON!

Get all the latest news from the 2011 COMMON Annual Meeting and Exposition right here from MC Press Online. Senior News Editor Chris Smith along with CL expert and Technology Writer Bruce Vining and PHP Author Jeff Olen will be covering the show for MC Press Online and blogging daily in the MC Press Industry Watch blog designed to give you news about what’s happening at the conference. To reach the Industry Watch blog, click on Forums at the top of the home page, then Blogs, or Click Here.

In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor