Maybe I’m getting old, but I seem to remember being able to create several levels of directory structure with one command. I currently have such a need, in an application that creates XML files in the IFS. Yet CL’s MAKE DIRECTORY (MKDIR) command fails with error message CPFA0A9. Am I imaging things, or has something changed?

–Lynn

My guess is that you’re remembering MS-DOS’s md command. The following example contains a command that creates from one to five directories as needed.

C:>md salesreports20071RegionC

CL’s MKDIR command can only create one directory level at a time. However, Qshell’s mkdir command can

We have a file that has no unique key. This means that we sometimes get duplicate records in the file. This does not cause us problems in RPG programs because we can read a record, make changes to it, and update it, whether we’re using native I/O or an SQL cursor. However, having duplicate rows is a problem when we use SQL outside of programs. If two or more records are identical, there is no way to code a WHERE clause that will select only one record. Or is there?

–David

It is ugly, but possible, David. Assume table MYDATA,

I recently activated a trial Capacity Upgrade on Demand (CoD) processor to increase my processing power on a System i 550 box. If you’re considering activating additional processors on your system, this week and next I’ll trace the steps I took to decide on activating another processor and how I got the process moving. Although there are a few pitfalls to avoid, adding extra processors to your machine isn’t that difficult.

What is CoD?

Capacity on Demand (CoD) is IBM‘s way of ensuring that you can quickly add extra capacity to later model System i servers, including models 550,