I came across a situation recently that I thought some of you might find of interest. It has to do with program references (i.e., which objects a program uses) and conditional compilation. If you use a documentation package, whether homegrown or commercial, you may rely on program references without being aware of it.

Here is my situation. As part of a conversion project, I have an RPG program that uses conditional compilation directives to select one of two SQL commands, like this:

D zKey            s              3a
D zData           s              5a

 /free
     *inlr = *on;
 /if defined(SomeCondition)
     exec sql
        select key, 

I need to copy the contents of a physical file from our production system to its counterpart in our development system, which is a separate logical partition. I have several ways to copy the file from the production system to the development system. However, error messages I get say that I cannot replace the data because the database file has triggers over it. Help!

–Tricia

You need to disable the triggers. Disabling triggers is most easily done if all of the triggers are active. Use Change Physical File (CHGPF) to disable the triggers.

CHGPFTRG FILE(MYLIB/MYFILE) TRG(*ALL) STATE(*DISABLED)

Then copy the

In recent articles, I detailed how to change the communications identity of one i5/OS box so that it can impersonate another system and take its place on the network. However, I glossed over one important step: how to restore the i5/OS System Distribution Directory (SDD) from one machine to another. This week, I correct that error by showing you how to transfer an SDD from one machine to another.

What Is the SDD?

Although an SDD sounds like something you might catch when you’re not being too careful about the company you choose, the System Distribution Directory has been