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 that deal with the same subject. As long as you’re changing PFs, consider taking a few minutes and right-justifying LABEL ON/COLHDG literals over numeric fields. Following this practice usually saves a few horizontal characters and always makes the output more readable.
Finally, using mixed case for table and column descriptions greatly increases readability and improves report writer output.