June 2000

• Street Talk - The AS/400 Banana-Peach Index; new e-mail server; effective security measures
• PTF Watch - Check out the latest significant HIPER PTFs for V4R1, V4R2, V4R3, and V4R4.
• In This Issue: Get Smart -
• From the Editor in Chief -
• Letters -
• The Revenge of the Midrange - The April correction in the stock market exposed the vulnerability of overvalued dot-com companies. In contrast, it made more traditional companies and AS/400 market hallmarks appear rock solid.
• Pssst! You There, Wanna Buy a Personal AS/400? - IBM has developed an AS/400 PC card that lets you run OS/400 on an IBM ThinkPad. But the company isn't sure that anyone would buy such a product. Would you?
• XML: Crossing the Boundaries - Extensible Markup Language extends the file description capabilities of DDS to other platforms, translates data from one format to another, and lets users access metadata directly.
• B2B e-Markets on the Rise - Nahid Jilovec says the emergence of industry-specific B2B e-markets heralds a new dawn for business-partner relations and supply-chain management.
• First Look: WebSphere Studio 3.02 - Paul Conte puts IBM’s flagship Web application-development tool through its paces and highlights important features you should consider when evaluating this type of tool.
• Building Web Pages with VARPG - Jef Sutherland explains how to create new static Web pages and update their content daily using VARPG programs and template HTML files.
• Fast Access to Database File Structures - Thibault Dambrine’s utility DBRPLUS displays physical and logical file information in an easy-to-read format, letting you quickly determine the structure and logical dependencies of a physical file.
• Automate Excel File Transfers with VBA - Ken Dafoe shows you how to use native Microsoft Excel and Client Access features and a VBA script to create a program that automates a Client Access file transfer and calls Query/400 with one click.
• Hot New Products -
• Automate Your Report Distribution via E-Mail - Companies that require distribution of spooled documents to multiple local and remote recipients may find Dynamic Systems Solutions’ Document Routing System much handier than moving paper around. This Demo Booth explains how to use the product.
• Generate a Simple AS/400 Java Report - Marty Wilber suggests that beginners postpone working with Java’s visual classes until they have a little more experience. Start small by creating this report application that you can run in batch.
• Configuring AS/400 IP Packet Filtering - Connecting your AS/400 to the Internet and then simply enabling the OS/400 TCP/IP servers is an open invitation to problems. But IP packet filtering will help protect your AS/400. Craig Pelkie explains all the steps.
• Add New Dimensions to Your Data Analysis - IBM’s Kent Milligan says that by storing multidimensional data in either DB2 UDB or the optimized Hyperion Essbase store, IBM’s DB2 OLAP Server for AS/400 1.1 provides flexibility for data analysis and business intelligence.
• Using AS/400 Security Auditing - Azubike Oguine explains how to use audit journals to track objects and monitor security-related activities on your machine. He also offers his audit trail and DSPAUDLOG utilities to help you automate your audit documentation.
• Backup & Recovery FAQs -
• I’m trying to save changed objects on my system. When I use the DSPOBJD command, the objects show a -
• Do any AS/400 tape devices support "tape mirroring" so I can create identical saves on two -
• In Focus: Expanding Frontiers: A New Generation of AS/400 Hardware -
• In Focus: Twinax Is Not a Ticket to a Deserted Island -
• Newswatch Listings -
• Tech Corner -
• Object’s Source File Info Not Displayed -
• Java Questions -
• Searching for Source -
• AS/400-to-Excel File Transfer Macro -
• Monitoring the QBATCH Subsystem -
• Remapping the Client Access 5250 Keyboard -
• FREE Opcode Equivalent in RPG IV? -
• RPG IV Style: Writing Solid Code - Programming defensively can prevent bugs from creating havoc in your programs. Julian Monypenny explains how to analyze and correct the risks in your coding techniques.
• Managing Web Server Growth - Mel Beckman describes several techniques for coping with growing Web server demand by improving Web server performance.
• Comparing the AS/400’s JDBC Drivers - In two tables, Rui Fan and Xiao D. Luo note the differences between the AS/400’s native JDBC driver and the Toolbox JDBC driver.