Embedding SQL in RPG IV--Episode II
by Joel Cochran

In the first installment of this article, affectionately named "Episode I," I presented the first half of an embedded-SQL primer. We discussed such heady topics as host variables and cursors, and it was a good start but far from complete. All of the examples in the first article were static examples, meaning that they had no true runtime dynamics. While the variable values could obviously change, the form and format of each SQL statement was constant. In Episode II, I am going to focus on one of the more powerful features of embedded SQL: dynamic SQL statements. READ MORE >

A Speedier CHGPF
Hey, Ted:

As a matter of policy, and to eliminate the CHGPF quirk you wrote about recently, I recreate all associated logical files when I change a physical file. I use a certain technique to make the conversion go faster. READ MORE >

   Admin Alert: Common Things to Do When Installing Third Party Products
   by Joe Hertvik

Before letting you install their packages, third-party OS/400 software providers usually ask you to inventory your system to ensure that it contains specific licensed programs, patches, or configurations that are compatible with their products. Filling out an OS/400 requirements checklist forces you to investigate your system configuration and then act on the results. Here are some common system requirements you may be asked to verify for a third-party install, and where you can find that information. READ MORE >

Reader Feedback and Insights

We value your feedback and insights. Feel free to send a letter to the editor. Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >

WorksRight Software
COMMON
Bug Busters Software Engineering