Saving and Restoring External SQL Routine Definitions
Hey, Mike:

A vendor whose software we use separates objects into two main libraries--a data library and an object library. I had to restore all the data, so I deleted the data library and restored it. After that, the application stopped working. The problem turned out to be that some stored procedures that they created in their data library got wiped out, and the Restore Library (RSTLIB) command didn't put them back. The story ends happily because the vendor had a program in place for just such emergencies, but (and I'm sure IBM disagrees), I consider this a big old bug in the SAVE/RESTORE command. If I restore a library, I want everything in the library restored. READ MORE >

Create Multiple Directory Levels in One Swell Foop
Hey, Professional:

Yes, you, the person who knows so much about making machinery serve your organization. You, the person who knows so many little, seemingly trivial and insignificant bits and pieces of information. Here's a bit of info that maybe no one in your shop knows, and it can come in handy. It comes from the IT Jungle Web forums. READ MORE >