December 1998

• In This Issue -
• Letters -
• 500 Y2K Lawyers at the Bottom of the Sea - Robert Tipton gives his ingredients for Year 2000 shark (lawyer) repellent: document and test everything and prepare for every contingency.
• AS/400 New Year's Resolutions I'd Like to See - Roger Pence looks forward to 1999 and outlines the AS/400-related enhancements he hopes for from IBM - and Microsoft.
• Newswatch -
• 14 Ways to Succeed at Project Management - Paul Conte shows how implementing iterative and incremental strategies, using pilot programs, and practicing good politics can make you a better project manager.
• Charting a Successful Course - Paul Kjer shows how you can use Gantt charts to plan and track projects.
• Ready for Domino? AS/400 Users Speak Out - Ann Hutchins, a NEWS/400 senior editor, reports the results of a NEWS/400 Web survey on AS/400 users' Domino readiness.
• ODBC Driver Keeps Things Cooking at Nabisco - Jeanne Huff describes how StarQuest Software's StarSQL Pro forms a key ingredient for success in Nabisco's move to TCP/IP and NT.
• Preview Domino 5.0! - Robert Tipton explores the latest version of Domino, which provides a slew of new features, including integration with the Internet and non-Notes databases such as DB2/400, a Windows-like interface, and the ability to easily manage and use Internet e-mail.
• 44 AS/400 Programming Tips & Techniques - "44 AS/400 Programming Tips & Techniques" offers helpful hints from a variety of authors on a variety of AS/400 programming topics, including RPG, ILE, CL, Cobol, SQL, Query/400, Java, and more.
• VARPG (Nearly) Does Java - IBM previews technology that lets the VisualAge for RPG graphical development environment generate Java applets; NEWS/400 technical editor Jef Sutherland takes it for a spin.
• 36 Networking & Systems Management Tips - "36 Networking & Systems Management Tips" offers helpful hints from a variety of authors on a variety of networking and operations topics, including TCP/IP, Client Access, Web, systems management, and security.
• Do I need to include the SAV (Save Objects in Directories) command in my save strategy to back up my -
• New Products & Services -
• Street Talk -
• When I save the QUSRSYS library, not all objects in QUSRSYS are saved. Is this a problem? -
• There is a new parameter on some of the save commands called USEOPTBLK (Use optimum block). What doe -
• Can I create *FMT3480 density tapes with a 3490 model F tape device? -
• What enhancements does the new 3570 model C tape device offer? -
• Resetting TCP/IP from a Remote Connection -
• Checking the Status of AS/400 TCP/IP Server Jobs -
• DNS Troubleshooting with NSLOOKUP and STRDNSQRY -
• TCP/IP Communications Trace -
• Picking Private IP Addresses -
• Automating FTP -
• Starting TCP/IP and Client Access Servers -
• Stop IE Dial-Up from Interfering with CA Connections -
• Set Client Access ODBC to Search Multiple Libraries -
• Associating CA Jobs with Users -
• Printing AS/400 Output to a Text File with CA -
• A Graphical Interface for Managing Stored Procedures -
• Web Development Version Control -
• Extending Net.Data Visual Widgets -
• Jumping into New Technologies -
• (Daylight Savings) Time Management with Domino -
• Handling Ownership of the NOTES.INI File -
• Configure Workstation Entries for Interactive Subsystems -
• Resetting a Disabled QSECOFR Profile -
• Who Belongs to That Group? -
• Creating Query-Ready Files -
• Managing Disk Use -
• Controlling Assistance Levels -
• Halve the Runtime of Long-Running Batch Programs -
• Work with Shared Pools and Performance Adjustment -
• Searching Spool Files with SEU -
• Using WrkActJob Sensibly -
• Defining OUTPUT(*OUTFILE) to Record Unsaved Objects -
• Use the Attn Key for Immediate Access -
• Fast Access to the Operator's Message Queue -
• Beware Password Exposure -
• AS/400 Security Advisor -
• Making System Value QCRTAUT More Restrictive -
• Hiding AS/400 Libraries from View in Network Neighborhood -
• LAN Printing Using PJL -
• Buying Time to Change APPN Attributes -
• Continuing a Character Literal in RPG -
• Get Details About ILE RPG Compile Errors -
• Use BIFs on D-Specs -
• Using Compiler Directives to Reuse RPG IV Code -
• Prototyping CL Commands in RPG IV -
• Use %REPLACE to Search and Replace -
• Handling Invalid Numeric Data -
• Convert Values Using V4R2's %CHAR -
• Using the Like Keyword with Prototypes -
• V4R2 %Equal vs. %Found with LookUp -
• Simplify Working with Character Strings -
• RCLACTGRP Gotcha -
• 5 Tips for Success with ILE Bound Calls -
• Using Arrays in CL -
• The Amazing CPYF! -
• Reread a File in CL After Reaching End-of-File -
• Find Commands Fast -
• Passing Parameters in CL Using SBMJOB -
• Copying Restricted-Access Objects -
• Target Spool Files with *SELECT -
• Using QCmdExc in CL Programs -
• AS/400 Toolbox for Java - Two Common Problems -
• Evaluating Java Object References -
• Java CLASSPATH Shortcut -
• Listing Directories in Java -
• Java Coding for Performance -
• Using SQL with Query Manager -
• Converting Character Data to Numbers in SQL -
• Overriding a Query's Files at Runtime -
• Changing Query/400's End-of-Report Line -
• Easy Data Import and Export -
• Query/400: Ignoring Field Case when Selecting Records -
• Using Variables in QRYSLT -
• Using RPG IV's *JOBRUN Special Value for Date Format -
• Finding Total Weekdays Between Two Dates -
• Checking for Leap Year in a CL Program -
• User-Defined Types in ILE Cobol -
• Changing the ACCEPT DATE Value in ILE Cobol -
• A Cobol Run Unit Quiz -
• A Cobol Run Unit Quiz -
• Define Compile Commands in CODE/400 -
• Printing to Spooled Files in REXX -
• A DSN-less ODBC Connection Using RDO -
• Obtaining ICF Information in an ILE RPG Program -
• Closing a TCP/IP Socket -