MAGAZINES

MC Press Resource Centers
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

December 7, 2011 | Volume 10 Issue 23

ISSUE HIGHLIGHTS

TOP STORY: Practical SQL: UDFs and Service Programs, Part II
FEATURED ARTICLE: Want to Know All the MI Object Types Supported by Your IBM i?
NEWS HIGHLIGHT: LANSA Announces LongReach Secure Mobile File Management for the IBM i
WHITE PAPER: A Visual Guide to Cost Effective Testing on the iSeries
Manage Subscription | Contact Us

Sponsor - The MC Press Bookstore
 
Now available in eBook format! In SQL for eServer i5 and iSeries you will learn about Structured Query Language (SQL), but with an IBM eServer i5/iSeries twist. With a practical "how-to" style, the book first introduces you to the basics essential for any developer to build a solid foundation. Then, the book examines--in detail--the many ways in which SQL functions on the iSeries. Make your database access cutting-edge with SQL for eServer i5 and iSeries. >>
Read More >>

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

With a little creativity, SQL allows you to add a form of overloading to RPG that can really extend your toolkit.

joe_plutaWritten by Joe Pluta

In the previous article in this series, I created a simple user-defined function (UDF) that acted as an SQL interface to an RPG service program procedure. It was simple and easy to do, but the emphasis was on simple. The UDF simply passed parameters from the SQL environment straight through to the RPG procedure and returned the result. This is enough in many cases, but at other times, you might want a little more flexibility.


Read More >>

Feature Article - Programming
 
Want to Know All the MI Object Types Supported by Your IBM i?

Retrieve the exact table of MI object types via the undocumented API QLICNV.

junlei_liWritten by Junlei Li

On IBM i, historically there are two flavors when referring to objects. At the MI level, MI objects are categorized by a 2-byte MI object type code (1-byte type code and 1-byte subtype code). At the OS level, external objects (also known as CL objects) are categorized by external symbolic type names—for example, *FILE. An external object may consist of one or more MI objects. Each MI object type also has a corresponding descriptive external object type name; for example, the external object type name of a cursor object (with MI object type hex 0D50) is *MEM (Member). As you might know, the number of MI object types changes from release to release. This makes sense for an object-based system that has been evolving continuously.


Read More >>

In the News

Read More >>
   MC-STORE.COM