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 2, 2011 | Volume 10 Issue 21


TOP STORY: Practical SQL: UDFs and Service Programs, Part I
FEATURED ARTICLE: Uncover the Secret of the Changed Object List (COL)
NEWS HIGHLIGHT: New Xcase Release Speeds Up DDS-to-SQL Migration
FORUM: Using Wildcards with readdir()
MC PRESS BOOKSTORE: Top 10 Best-Selling Titles
Manage Subscription | Contact Us

Sponsor - Business Computer Design

Instantly get your Green Screens to the Web

BCD's Presto instantly web enables ALL your IBM i green screens. Install it in under an hour and see immediate results.


  • No RPG, COBOL or DDS code changes
  • Further enhance screens with the visual editor
  • Add new functionality for easier data entry
  • Deploy a completely browser based solution
  • Access with tablets and smartphones
  • No ActiveX, Window Servers, WebSphere,
    or additional IBM i software required

Get a Free Trial or View a 2 Minute Video



Feature Article - Programming
Practical SQL: UDFs and Service Programs, Part I

In this installment of our continuing series on using SQL in real business applications, we introduce the concept of invoking service programs from within SQL.

joe_plutaWritten by Joe Pluta

We continue to provide you with examples of integrating SQL with traditional RPG. In this article, we're going to focus on how we can use a service program to extend SQL and provide an essential feature that SQL is sorely lacking: converting binary data in a character field to numeric values. Note that this is the opposite of something like the HEX function, which returns the hexadecimal representation of a field. This function will take some alphanumeric data, either in packed or binary form, and return the numeric value the data represents. This practical extension to SQL can be used by any shop.


Feature Article - Programming
Uncover the Secret of the Changed Object List (COL)

Discover the essence and usage of the COL associated with a library.

junlei_liWritten by Junlei Li

In the reply post in 2009 to a question called "Best Way to Check if a Library Has At Least 1 Changed Object" in the midrange-l mailing list, CRPence mentioned the term "changed object list" (COL). The following is the original reply post by CRPence. (Sorry, Chuck, I don't know your full name.)


Most Popular MC Press Books

Top 10 Best-Selling Titles

  1. Control Language Programming for IBM i
  2. Subfiles in Free-Format RPG
  3. SQL for eServer i5 and iSeries
  4. IBM System i APIs at Work
  5. Selling Information Governance to the Business
  6. IBM i and i5/OS Security and Compliance
  7. Qshell for iSeries
  8. Complete CL
  9. The IBM i Programmer's Guide to PHP
  10. Programming in RPG IV


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor