December 2000

• In This Issue: In Control -
• Letters -
• Will You Be Obsolete? - Roger Pence advises you to choose your continuing education wisely so you'll be prepared for the future - regardless of the AS/400's fate.
• SQL Support and IBM's eServer Strategy - Carson Soule says IBM's new eServer strategy means IBM must give the AS/400 database the same DB2 UDB features and interfaces that the other IBM servers have - including full-function SQL support.
• Street Talk -
• PTF Watch -
• In Focus: Top-Secret Program Finds and Exterminates OS/400 Bugs -
• In Focus: IBM's Cluster-Proven Team Off to a Slow Season -
• In Focus: Rochester Gets New Chief Exec -
• Hot New Products -
• Looking Back - and Moving Forward - Nahid Jilovec reflects upon the events of 2000 and projects how current trends may evolve in the coming months.
• A Quick Guide to AS/400 Data Transfer - The abundance of data-transfer methods available on the AS/400 gives you flexibility - once you sort through the options. Use this handy table from Ann Hutchins and Michael Otey to dispel your confusion.
• The ABCs of SQL: Get Ready, Get Set! Using SQL's Set Statement - Mike Cravitz shows you how SQL's Set statement lets you easily calculate the day of a week from a date using the DayOfWeek function and count the number of digits in a numeric field.
• What's New with OLE DB in the Client Access Express Beta? - IBMer Brant Klepel takes a sneak peek at some upcoming enhancements to the Client Access Express OLE DB provider - such as support for VB 6.0 ActiveX controls, Unicode, and new custom properties - that make it easier for developers to code data-access applications.
• Load 'n' Go: Create a Lookup Window for Users - Long Nguyen explains that by using his handy utilit, you can avoid having to write a separate lookup window program for each input file.
• Managing the AS/400 Using SNMP - Mel Beckman explains how to configure and use Simple Network Management Protocol (SMNP) to manage your AS/400 network.
• Tips for Programming - These AS/400 programming tips lists several "plays" you may want to run in your shop. Add these tricks to your programming play book, and watch your team's efficiency improve.
• Tips for Networking & Systems Management -
• Tech Corner -
• Copying a File from CD-ROM -
• Securing Data Backup -
• Retrieving a Spooled File Number -
• Working with Member Data File -
• Invoking Prototype with a Procedure Pointer -
• Accessing a Remote AS/400 Database via SQL -
• Executing Multiple SQL Statements -
• Making Database Reorg Easier -
• Using RUNRMTCMD without an IP Addesss -
• Copy/Paste Parameters -
• Sorting on Absolute Value in Query/400 - Lynne Noll explains how to sort on absolute value in Query/400
• A Modular Programming Method for RPG -
• Numeric Parameters in OPNQRYF -
• Redefine Edit Codes in SQL -
• Use a Skeleton Line to Speed Up Coding in SEU - Gene Snipes explains how to create a custom skeleton line to speed up the coding process when you're using SEU (without prompting) to enter RPG program calculation specs.
• %WLDCRD in OPNQRYF - Istvan Buknicz explains how to use the OPNQRYF (Open Query File) command's built-in %WLDCRD(...) function to perform a wildcard scan of a string upon a pattern
• Mapping the Grave (') Character - Tory Bennetsen tell you how the quotation mark key can become part of your everyday work.
• Maintaining Database Relations - Gaya Dahanayake offers a tip for maintaining database relations between a physical file and its logical files when copying or moving a phsical file and its logical files from one library to another.
• QShell Pipes - Dan Darnell offers an example of using QShell's inherent capability to route the output of one utility to the input of another utility through a facility konwn as a pipe.
• Specify SRCDBG as a Default Option - Denise Smith explains how yur can specify SRCDBG s a user-defined PDM option.
• Print Out Screen Layouts in SDA - Eileen Nicol suggests pressing F17 to print out screen layouts when you're working with a format in SDA.
• Control C Program Object names - Kent Milligan explains how your can control a program object name by adding the SPECIFIC name clause to your CREATE PROCEDURE statement when you create an SQL stored procedure.
• Showing Submitted Jobs - Robert Goodwin offers code you can use to show a user that jobs have been submitted from a CL menu.
• Using the QSH Utility -
• Eliminating Non-Error Exceptions - Scott Cole offers code you can use in control language programs (CLPs) when you want to eliminate the exceptions that aren't truly errors in the job log.
• Invoking System Command Line in SDA - Shyam Gummidela explains when you can use the F22 key to involve the system command line while you're in SDA
• Saving Commands for Future Use -
• Sending Event Notification Messages -
• Copy Data to a Shared Folder in CSV Format -
• Changing Sockets to Nonblocking Mode -
• Disable Null-termination of Character Strings -
• Security 101: The "Security Tools" Menu -
• "Fast Path" to Commands — AS/400 Style -
• Converting an AS/400 Report to Excel -
• Finding a Message in the History Log -
• Using Varying Length Fields for Efficiency -
• Sending Spooled Files to Another System -
• Message File Frivolity -
• Restricting Telnet Port Use -
• Identify Files Renamed by a RSTOBJ -
• Deleting Duplicate Records from a File -
• Prioritizing Interactive Jobs -
• Where Am I? -
• OpsNav SQL Script Window Provides Access to PRTSQLINF - Kent Milligan explains how you can put together an OpsNav SQL script file to both execute the PRTSQLINF command and analyze the results — all from the OpsNav interface.
• Receiving Completed Job Messages -
• Easy Switching Between User IDsin OpsNav -
• Checking Password Violations -
• Configuring an ASCII LAN Printer -
• Retaining Spooled Files After Printing -
• Displaying File Contents Without Using Query/400 -
• Printing Level Breaks on Every Line in Query/400 -
• Landscape-to-Portrait Output Quick Change -
• Resequencing Columns on the WRKACTJOB -
• Combating V4R4 FTP Server Shutdowns -
• Remote Management with Operations Console -
• Printing Barcode -