Configure the SQuirreL alias properties and preferences commonly used by RPG programmers.

Written by Tom Snyder

To complete my SQuirreL SQL client series, I will explain how to set up your schema and alias properties, such as library lists, and your formatting within the SQuirreL SQL client. I will also talk about how these settings impact your client to achieve the results that you desire.

Easily find text strings, regardless of case.

Written by Bruce Vining

In the last article, "Reading a Message File," we used the Retrieve Message API QMHRTVM to sequentially read the messages of a message file and display them using a subfile. In this article, we'll implement a find capability that will allow us to quickly find all messages containing one or more character strings (words).

Extend the life of RPG applications or migrate to a new language and platform, but first restructure your legacy RPG programs into a modern architecture.

Written by Databorough Services

Editor's Note: The following is taken from the white paper "A Visual Guide to Automated MVC Reengineering for RPG Applications," available for download free from the MC White Paper Center.

This paper has the following sections:

• Three steps to new and improved systems
• Why reengineer?
• Bad practices of reengineering—what not to do
• Best practices—two good options
• Automated restructuring and modernization of monolithic legacy RPG code (Overview, Restructuring RPG—the details, and Converting Restructured RPG to Another Language)