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 19, 2010 | Volume 7 Issue 46


TOP STORY: The CL Corner: Reduce Those Annoying Substring Operations
FEATURED ARTICLE: German Programmer Devises Novel Way to Access Any Remote DB from IBM i
NEWS HIGHLIGHT: CCSS Releases Primer Detailing Common but Costly Disk Problems
FORUM: Using Assignment Operator with Java Objects
ON-DEMAND WEBCAST: SkyView Security Compliance Solution featuring Audit Journal Reporter. Host: Carol Woodbury  
BLOG: System i Management Tips

Manage Subscription | Contact Us

Feature Article - Programming
The CL Corner: Reduce Those Annoying Substring Operations

It's simple if you use *Defined storage.

bruce_viningWritten by Bruce Vining

A pet peeve of mine is going into a CL program to make some modifications and then encountering long sequences of Change Variable (CHGVAR) commands utilizing %substring operations in order to access, and then update, data stored in the local data area (LDA). The approach of using the LDA for program-to-program communication is, in many companies, done as an alternative to passing parameters to called or submitted programs. And over the years many of these companies have developed standards addressing how the LDA is laid out for this form of communication. Actual usage of the LDA, however, is often left to the individual developer in terms of implementation. In this article, we will review one possible approach to improve programming productivity when using the LDA.


Feature Article - Programming
German Programmer Devises Novel Way to Access Any Remote DB from IBM i

Still a work in progress, ArdGate allows users to insert, update, and delete data with interactive SQL, QMQRY, and embedded SQL.

chris_smithWritten by Chris Smith

If you want to access data in the DB2 for i database from a remote computer, it's not that difficult. However, if you are working on an iSeries and you wish to connect to a remote database server to manipulate data, it can be a bit of a challenge.


In the News

Support MC Press - Visit Our Sponsors


Forums Sponsor





Search Sponsor