One of the nicest features of DB2 on the IBM i is the integrated journaling. This article shows you how to use SQL and journaling together.

Written by Joe Pluta

Journaling has been an integral part of the DB2 database since long before it was called the DB2 database. In fact, journaling predates the IBM i and even the AS/400; journaling was introduced on the System/38 way back in the days of cave computers. Journaling provides a number of important capabilities, including commitment control and high availability, but in this article, I'm going to stick to one of the most basic features of journaling: change logging.

Join IBM’s Mark Shearer and Vision Solutions’ Ed Vesely for an inside look at the state of resilience on IBM Power Systems, including exclusive market research. Learn how the latest IBM initiatives and performance breakthroughs can benefit your business, then drill down into the findings of a new study of 7,000 IBM i and AIX users on how they are meeting their data protection and recovery challenges. Click to view this On-Demand Webinar Now!

Secure your data using encryption/decryption APIs within RPG.

Written by Tom Snyder

The encryption/decryption APIs can be difficult to work with, so let's create some procedures to simplify all of the details of the initialization and data structures. We'll create the functionality that we are really looking for through the simplicity of reuse!