Why SQL? Why Now?
by Raymond Everhart

SQL has been available on the AS/400 and iSeries for years. When SQL was first introduced, it was not widely embraced, because of limitations and performance concerns. Since then, IBM has improved SQL on the AS/400 and iSeries so dramatically that in some cases it outperforms “native” RPG and COBOL record-level access. In spite of the many improvements, many programmers have not yet explored what SQL can do for them. READ MORE >

Deleting with a Generic File Name
Hey, Ted:

I've been working on the AS/400 for almost 15 years now, and I've always thought that a physical file could not be deleted until all the logical files based on the physical file had been deleted. However, while working on a problem dealing with deleting a physical file when a logical may or may not exist, I tried using a generic file name. My reading of the DLTF command description led me to believe that the files would not be deleted. To my surprise, the files--the physical file and the two logical files--were deleted. Did I misunderstand the description? Is this an undocumented feature? Has everyone but me known this for years? READ MORE >

Functions Can Modify Parameters, Too
Hey, Ted:

Steven Gray suggested that it's a good idea for an RPG function subroutine to return a data structure. I think he's on the right trail but barking up the wrong tree. Barbara Morris pointed out that it's more efficient to modify a data structure as a parameter of a subprocedure. I suggest that the best approach is to combine the strengths of the two methods. READ MORE >

Admin Alert: Three Common Mistakes in CL Administration
by Joe Hertvik

With a mature operating system like OS/400, there are plenty of subtle tricks you must understand in order to ensure that you are administering your system correctly. This week's "Admin Alert" looks at three common OS/400 administration mistakes and explains how to avoid them and keep your shop running smoothly. READ MORE >

OS/400 Alert: Spoofing and Demonstrations
by Shannon O'Donnell

In this issue of "OS/400 Alert," I'll alert you to the concept of spoofing and offer suggestions on how to protect yourself from it. In addition, I'll tell you know about some useful technology demonstrations made available by IBM for the iSeries Navigator tool. If you have been wanting to learn how to use iSeries Navigator for your operation but were not sure what it could offer you, you won't want to miss out on these great demos. Finally, I'll tell you about the viruses that are causing this week's worries. READ MORE >

Reader Feedback and Insights

We value your feedback and insights. Feel free to send a letter to the editor. Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >