Staggering SQL String Handling with Regular Expressions
by Michael Sansoterra

"Empower SQL with Java User-Defined Functions" explained how to create UDFs with Java and to register them for use with SQL. This article will illustrate the usefulness of the regular expression functions created in the previous article. Who cares if you don't know Java! Read on anyway, because one benefit of UDFs is that you don't have to know anything about what they're written in or how they're implemented. All you need to know is how to use them. READ MORE >

Binder Source: The Little Language That Could
by Joel Cochran

In "Service Programs with a Smile" I explained how to make ILE program maintenance easier by creating service programs to manage procedure modules. In examples given in the article, I specified the EXPORT(*ALL) attribute. I also said this is not the best way to manage service programs, because of the maintenance challenges it creates. Maintenance is always an uphill battle, but you can make it a lot easier with help from a little language. READ MORE >

Control Access Path Rebuilding
by Kevin Vandever

Most of you probably let the system take care of itself after an initial program load, right? We normally do, too. But a couple of times in the past we waited while access paths that we really didn’t care about at that particular time got rebuilt while the access paths we were really waiting for sat idle in the queue. If only there was a method, or methods, to control how and when access paths get rebuilt. Aha! But there are. Read on to find out more. READ MORE >

OS/400 Alert: OS/400 Passwords Can Be Seen
by Shannon O'Donnell

This week I'll explain how easy it is to view and steal encrypted OS/400 passwords, and how you can prevent such activities. Although the technique has been available for several years, it's likely that most people just never considered this vulnerability to OS/400 security. I'll also tell you about a vulnerability in Internet Explorer that lets Web sites install and run programs on your PC, a virus that can steal your credit card information, and my favorite PTFs of the week. 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 >