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!

Featured White Paper:

Bar Code / RFID Label Printing, Avoiding the Integration Traps

T.L. Ashford & Associates, the leader in bar code labeling software for the IBM i is sponsoring a FREE WHITE PAPER by Thomas M. Stockwell. This white paper examines three approaches to ADC integration with IBM i. It identifies the integration traps commonly experienced by business and then examines a better approach using native IBM i labeling software specifically designed for the IBM i architecture.
Download this NEW White Paper Today!

Don't miss these great offerings in the MC Press White Paper Center:

• Aberdeen Group White Paper: The Importance of High Availability; Continuous Applications and Data Recovery
• iSeries-AS/400 MICR Check Printing
• Executive Overview: Simplifying the Management of IBM i Environments
• Replacing IBM Query/400: Understanding Your Options
• Research Study: The State of Resilience and Optimization on IBM Power Systems
• SYSTEM i MODERNIZATION SURVIVAL GUIDE
• What Every Healthcare IT Manager Needs to Know - How to Solve Downtime Challenges to Patient Care, Operations and HIPAA Compliance
• Compliance without the Complexities
• Managing Changes to Critical Data
• The Data Protection Benchmark Report- The Road to Recovery
• Bringing Mashups to Your Enterprise Business Applications
• Executive Overview: System Migrations without Business Downtime
• Paperless Customer Service - Streamlining Customer Service Processes
• Get the Facts: Real-Time, On-Demand Information for Business Intelligence and Data Integration
• Beyond the Security Breach: Protect Sensitive Data Using Encryption & Key Management (USA and CANADA only!)
• Best Practices: The Fundamentals of Document Automation
• Journaling and High Availability - Understanding IBM i Data Protection
• SOA What? Why SOA is Critical for iSeries RPG Shops
• High Stakes of Data Availability: An Executive Guide to IBM iSeries Recovery Options (USA only!)
• Case study on Sperian Protection’s Paperless Transition
• Keeping your System i Applications Relevant in a Service-Oriented World
• Best Bets for iSeries Rapid Recovery with Virtualization: An Executive's Guide to Affordable IBM iSeries Recovery in 12 Hours or Less (USA only!)
• Please send me a link to the free white paper "ARCAD and the ITIL Framework."
• Supply Chain Synchronization: Recession-proof Strategies for Improving Efficiencies
• Revolutionizing System i Application Modernization
• THE EIGHT PILLARS OF AN ENTERPRISE APPLICATION ARCHITECTURE
• Get the Facts on Information Availability: How to Solve Downtime Challenges to Manufacturing and Supply Chain Operations
• Product case studies and registration details for a FREE product demo (USA and CANADA only!)
• Converging Voice and Business Applications: A Practical Approach (USA and CANADA only!)
• 51 Things you can Automate on your System i (iSeries) – and prove Return on Investment

Let the MC Webcast, Whitepaper, and Software Centers help you make a New Start in the New Year and you might just win a New Netbook by Dell. Visit today to find an amazing variety of IBM Power Systems solutions to make your job easier and more productive. While there enter to win a Dell Netbook…a $300 value! One lucky winner will receive one of their very own.

Have a White Paper you would like to list? Click here or call (208) 726-6822 for information.