Embedding SQL in RPG IV–Episode II

August 24, 2005 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.

Picking Up

A Speedier CHGPF

August 24, 2005 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.

I first use the Move Object (MOVOBJ) command to move the logical files to a temporary library. When the new logical file is recompiled into the original library, the access path will be shared and the compile will be done in a snap. Then, I delete the old logical file from the temporary library and I’m done.

Here are two more tips

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

August 24, 2005 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.

Checking for Installed OS/400 Licensed Programs

Some packages specify that other OS/400 licensed programs must be installed on your partition before they will run.