I suppose everybody knows that the Copy File (CPYF) command can copy data from one database file to another. And I suppose everybody knows that, depending on the MBROPT parameter, the data in the source file (the “from” file) can either replace or be added to the data in the target file (the “to” file). Furthermore, I suppose that some people know that the MBROPT(*UPDADD) option causes the system to replace the records that have matching key values and add records with no matching key values. But does anybody know how to add the records that don’t have matching key

I am writing a CL program in which I pass variables to the Change User Profile (CHGUSRPRF) command. The command fails when I try to use a qualified name containing a single value like *SAME or *NONE. If I use one variable for the qualified parameter, *SAME and *NONE work, but the compiler won’t allow me to put both library name and program name into one variable. How can I pass qualified names that allow single values as variables to commands?

–Brian

Use two variables for the qualified name in your CHGUSRPRF command. When you need to use a single

I have recently received several emails asking about the best way to automatically delete user profiles that haven’t been used for a specific number of days. This is a requirement for several reasons, including Sarbanes-Oxley compliance. While I’m not sure any process for the automatic deletion of user profiles is perfect, here’s how I would approach this issue by using a home-grown technique.

Please note that this technique is experimental and it is not bullet-proof. I offer it as an exercise to help you satisfy your own automatic deletion requirements. However, you should be extremely careful when putting an automatic

At the request of a number of IT Jungle Forums users, we have added a new Job Postings section to the forums. Headhunters and companies sometimes abuse forums by posting open job positions all over the place, and we are having none of that. We want to help people get work and companies find good people, so there are some ground rules.

We have created specific areas for people looking for jobs and companies looking for people, and in our no-nonsense fashion, these areas are called Job Postings–People Looking for Work and Job Postings–Companies Looking for People.

Anyone who