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

June 5, 2013 | Volume 12 Issue 11


TOP STORY: Practical RPG: BLOBs, CLOBs, and XML Part 2
FEATURED ARTICLE: Access Database Files Dynamically in RPG
NEWS HIGHLIGHT:  mrc Brings Full Email Integration to m-Power
FORUM: Print Bar Graph from RPG
MC STORE: Top 10 Best-Selling Titles
MC VIDEO PORTAL: Why Do a Security Review?
EVENT: How to Control Your Entire AP Cycle for IBM i

Feature Article - Programming
Practical RPG: BLOBs, CLOBs, and XML Part 2

You want to use LOBs in your RPG program but don't know where to start; read this article to find out how!

joe plutaWritten by Joe Pluta

In the first article in this series, I identified situations where it is preferable to store stream data in a database rather than in the IFS. Specifically in my case, I had literally millions of stream files proliferating in the IFS and causing some real processing issues. My alternative was to store the stream files in the database. Implementing LOBs is not difficult, but it does require a number of steps, many of which may be unfamiliar to most of us.


Feature Article - Programming
Access Database Files Dynamically in RPG

Learn how to access database files via the UFCB. This practical example repairs invalid data in OPEN fields due to DBCS character truncation in a random database file.

junlei liWritten by Junlei Li

Programs written in IBM i high-level languages (HLLs) such as RPG are bound to files they access statically, or in other words, at compile time. However, in VRM610, RPG was enhanced to allow passing files as parameters to RPG programs and procedures (see File Parameters). The enhancement makes accessing files from RPG more flexible, but RPG still cannot access a file as dynamically as the record I/O routines of the C libraryfor example, it can't open a file by name and then get the record length of the opened file, which is needed to perform further file I/O.


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor



MC Video Portal

Before you get hacked, fail your next audit or if you simply can’t bear to see your company’s name in tomorrow’s headlines contact SkyView Partners for your Security Check-up.

SkyView Security Check-up for IBM I & i5/OS is a subscriber-based service brought to you by Carol Woodbury and SkyView partners, for identifying security vulnerabilities on your IBM I and i5/OS systems.

The normal price for a SkyView Security Check-up is $2,500 per partition.

Act NOW and get this for $1,750 per partition.

A 30% discount, offered exclusively through MC Press Online.

Best of all…..if we find nothing it is FREE!