Where's the Other MBROPT Option?
Hey, Ted:

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 values without updating the records that do? READ MORE >

CL's Null Value
Hey, Ted:

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? READ MORE >