Pivot Data with SQL/400
by Michael Sansoterra

Have you ever received an annoying report request from management asking that the data be presented summarized in columns and rows, rather than just by rows? To further complicate things, the data to be presented in the columns wouldn't necessarily be consistent between runs, so you had to dynamically calculate column contents. Sound familiar? Cross tab queries provide the perfect solution for just such a dilemma. READ MORE >

We're Off to See the Wizard of WebFacing
by Raymond Everhart

When Dorothy needed to get home from the land of Oz, her only hope seemed to rest in the powerful and mighty Oz. With great fear, she entered the throne room to seek a favor from the mysterious Wizard of Oz. Your first encounter with the Wizard of Webfacing does not have to be nearly that scary. Let's pull aside the curtain and take a look at the WebSphere WebFacing Wizard. READ MORE >

Creating and Consuming an AS/400 Web Service
by Rick Farina

In "Web Services and the AS/400," I explored the importance of Web services and the role I expect them to play in the AS/400 environment. To exemplify how easily they are developed and implemented, I used the Microsoft .NET environment to create a Web service, and a browser to consume it. In this article, I will write a .NET client/server program to consume the Web service programmatically and to show how seamlessly the AS/400 fits in the Web services environment. READ MORE >

The Java-Based iSeries System Debugger
by Kevin Vandever

For so long we iSeries programmers have used the green-screen debuggers STRDBG (Start Debug) and STRISDB (Start Interactive Source Debugger) to solve our debugging needs. Although they're not the best or the most robust in the industry, these debugging tools have, for the most part, done the job quite satisfactorily. However, in the last few years it seems as if system debuggers have been falling out of the sky and now we iSeries programmers have many options from which to choose. In this article, I am going to talk about one of those options. READ MORE >

Reader Feedback and Insights

We value your feedback and insights on the OS/400 market. Feel free to send a letter to the editor. We will consider your letter a candidate for the reader feedback column for this newsletter, but we will contact you before we make your e-mail public. READ MORE >