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

Sponsor - Linoma Software
Securing File Transfers… Moving Beyond FTP

Free Webinar on December 2nd, 12 p.m. CST 

The prevalent use of standard FTP has become a huge security risk. It is critical to protect data transfers using secure FTP and other encryption standards. Attend this webinar and learn:

- The advantages and differences between FTPS and SFTP secure protocols
- Authenticating servers using passwords, keys and certificates
- Using OpenPGP and ZIP to encrypt files at rest and on the move
- Generating audit trails…and more!



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





MC Industry Blogs

BLOG: System i Management Tips from Vision Solutions, Inc.


Latest Posting: 3/26/10 Additional ways to see the contents of a user space (*USRSPC)


01/29/10 How to determine the jobs or objects responsible for generating journal entries in a journal receiver?

12/17/09 How to search for text in a file at the member level

11/20/09 Simplify replication of devices between two systems by matching hardware resource names

10/21/09 Know the impact of using the ENDJOBABN command

10/2/09 How to rapidly set up a network printer using IBM Personal Communications