October 2002

• Using SQL for File-to-File Updates - Users love to create transaction batches in Microsoft Excel and then ask developers to accept their spreadsheets as file maintenance application input. Here's how to update master files with transaction records using SQL.
• Tech Corner -
• f.y.iSeries -
• Web Application Server Options - So WAS is for complex apps with heavy Web traffic, and Tomcat is for basic apps with light traffic - right? Actually, there are several more points to consider if you want to choose the best Web app server for your needs.
• In This Issue: Welcome! -
• Working with Shells on OS/400 - OS/400 now provides an extensible scripting environment to let you work with programs and files, automate common tasks, and control the flow of input and output. What's more, OS/400 shells are IFS-enabled.
• Getting Started as a WAS Administrator - Administering a WebSphere environment is more complicated than managing other licensed IBM products on an iSeries. Here's a checklist of tasks and Web resources you can use to educate yourself.
• WebSphere Reality Check - What is WebSphere Application Server, how does it integrate with other software components, and what is its role in Web-enabled applications? This article tackles these questions and highlights the various technologies available to build Web apps.
• Programmer's Notes - Using this data-structuring technique, you can avoid record locks that crash backup jobs - without sacrificing database integrity.
• When Is PowerPC Not PowerPC? - If OS/400, the fundamental operating system of the iSeries, uses neither the PowerPC nor the POWER architectures, what does it use? Find out here.
• Hot New Products -
• A Talking Point for Your Legacy Apps - Ohio Data Transfer's DTT1000 Voice Response Unit is an integrated hardware/software package that lets you voice-enable legacy iSeries applications and build new ones.
• iSeries Dilemmas - It's easy to second-guess IBM's decisions about the iSeries' future, but the system faces formidable dilemmas in terms of marketing, scalability, and the future revelance of OS/400.
• Letters -
• Dr. I. Doctor - Dr. I. Doctor discusses 802.11a vs. 802.11b in mobile applications and changing the DHCP default gateway.
• Problem Merging Field With Word Doc -
• Determining Required Media Space -
• Non-FTP File Transfer Options -
• Hot Tip: Extracting Last Month's Data With Query/400 -
• Getting Started with Wireless - Many Lotus Notes users feel overwhelmed by all the different products, technologies, and issues involved with mobile computing. This look at the various solutions, devices, and technologies will help you choose the right mobile solution for your company.
• Second-Generation Wireless Applications - You've got applications. You've got wireless devices. You've got to make them work together. Learn how to rework your application interfaces and security to play well in the wireless world.
• The Evolving State of Wireless Standards - Although there's little agreement on a worldwide standard for wireless technology, an explosion of services and protocols means healthy competition and a promising future for handheld devices.