Another Room with a View

Hey, Howard:

I'm writing about your response to Dave in "A Room with a View." You included a couple examples of when views are useful, which I appreciated. But I have a question about how using a view affects performance. You mentioned in one example that logicals were replaced, in part, by views and in part by embedded SQL statements, in a bid to cleanup logicals and improve performance. Does this mean that views are different from logicals when it comes to system performance?

READ MORE >

Job Scheduler's Other Defaults

Hey, Ted:

We used the Work with Job Schedule Entries (WRKJOBSCDE) command to call an RPG program. The scheduled job ran reliably day after day. Then we wrote a CL program that did some preliminary processing before calling the RPG program. We changed the job schedule entry to call the CL program instead. The CL program ended abnormally because it couldn't find a command in the library list.

READ MORE >

Reader Feedback and Insights: More on Trigger Problems with Restored Library

The tip from Matanja was good ["Trigger Problem with Restored Library"]. However, once the Reclaim Storage was completed, did the program that removes the triggers have to be rerun? Did the RMVPFTRG command then work? Or does the RCLSTG command automatically remove the triggers?

--Doug

Corrections

The article "Batch FTP Under ILE" has been corrected since its original publication. In the second section of code, *CALLLLVL (four L's) has been corrected to read *CALLLVL (three L's). Guild Companies regrets the error. [Correction made 02/28/03.]