December 1996

• In This Issue -
• Letters -
• AS/400 Holiday Wish List - Need some inspiration for writing your own wish list to IBM Rochester or IBM Toronto? Chris Miller gives you a glimpse of what some of your colleagues are requesting this holiday season.
• Shooting the IT Rapids in 1997 - Robert Tipton says it looks like rough waters ahead for IT managers! Strap yourself in, and get ready for a wild ride through the white waters of network computing, new PC policies, a revival of traditional computing issues, and the Year 2000 push.
• Newswatch -
• EDI on the Internet - The Internet provides fast, flexible EDI transmission at low cost but doesn't offer the monitoring and reporting services of a value-added network (VAN). Electronic commerce specialist Nahid Jilovec compares the Internet and VANs in terms of reliability, performance, and security.
• 69 AS/400 Tips & Techniques, Part 1 - 69 AS/400 Tips & Techniques offers helpful hints from a variety of authors on a variety of AS/400 topics, including ILE, DB2/400, SQL, Query, RPG, CL, date operations, system management, SEU, and more.
• V3R2 RPG IV - More Function for CISC Systems - V3R2, the last OS/400 release for the CISC AS/400s, adds or enhances a great deal of OS/400 function. In this article, Bryan Meyers focuses on V3R2 enhancements to RPG, such as "no-cycle" RPG, subprocedures, procedure prototyping, free-form procedure and program calls, integer data types, and date-processing improvements.
• 19 Communications Tips - "19 Communications Tips" offers helpful hints from a variety of authors on a variety of communications and connectivity topics, including Client Access, the Internet, and TCP/IP.
• AS/400 Telnet Tricks - John Enck explains how you can use the standard version of TCP/IP's Telnet to let Windows 95 or NT workstations access an AS/400 or access DOS from a 5250 terminal with the help of Windows NT Telnet server software.
• 13 Client/Server Tips - "13 Client/Server Tips" offers helpful hints from a variety of authors on a variety of client/server programming topics, including ODBC, the Client Access APIs, and IBM's and ASNA's visual RPG products.
• New Products & Services -
• Reconditioned and New IBM Terminals - Ted Hooten reviews AS/400 terminal options and highlights some good buys in new and used displays.
• AS/400 Product and Service Resellers - John Ghrist reports on the product and service offerings of 25 AS/400 CPU resellers.
• IBM Announcements -
• Street Talk -
• Beware IBMers Bearing Defaults -
• Creating ILE Service Programs -
• Using Activation Groups -
• Using CEEHDLR in ILE Procedures -
• Reducing ILE Program Size -
• Optimizing Programs -
• Using Binding Directories -
• Using MONMSG CPF0000 in ILE -
• Reduce Static Storage by Eliminating Unused Fields -
• Reduce Static Storage with Pointers to Arrays and Tables with Static Data -
• Reduce Static Storage with Pointers to Arrays with Changeable Data -
• Making a Database READ Wait -
• Running Commands from Interactive SQL -
• Running SQL in Batch -
• Adding Long Comments to Database Items -
• Avoiding Phantom Updates Through SQL Views -
• Extending CRTSQLRPGI's Parameters -
• Checking the SQLState Variable for Embedded SQL Statement Completion Status -
• Making Query Case-Insensitive -
• Creating Long Alias Names for SQL Columns -
• Retrieving Zero or Another Value Instead of Null -
• Centering Text in RPG -
• Finding the Length of a String -
• Record Lock Messages in the PSDS -
• V3R2/V3R6 Field Definitions -
• LIKE Is Not Like *LIKE DEFINE -
• Parameters and the PSDS -
• RPG Length Notation -
• Positioning Subfields -
• Using the Attention Indicator Byte -
• Format Error Text Returned by APIs -
• Beware V3R1 CHKOBJ Changes -
• Defining Subarrays -
• Simulating Named Indicators -
• Coding Compile-Time Data -
• Watch Where You Put That "OR" -
• Remapping Externally Described Fields to Arrays -
• Coding Data Structures -
• Assigning Generic File Information Data Structures -
• Create Shorthand Commands Using QCMDEXC -
• Using MRGSRC with Only Two Source Members -
• Speeding Up CPYF -
• Use CHGVAR and %SST to Manipulate the LDA -
• Numeric Elements in Mixed Lists -
• Avoid Truncation -
• Change Default Compiler or Compiler Options -
• Client Access for Windows 95 Eases Multiple Connections -
• Configure Client Access for Windows 95 with the Easy-Start Wizard -
• Run Client Access for Windows 3.1 Under Windows 95 -
• Obtaining Client Access for Windows 95 Service Packs -
• Disable Client Access for Windows 95 Password Caching -
• Merging Client Access and Windows 95 MAPIs -
• New AS/400 and Client Access for Windows 95 Mail Support -
• Connecting Client Access for Windows 3.1 to Multiple AS/400s -
• Carefully Code CGI Programs that Process HTML Forms -
• Secure the AS/400's Internet Access Points -
• Enforcing No Sign-on to WSG -
• Working with WSG Character Sets -
• Checking LPR User Profile Authority -
• LPR User Profile's Library List -
• Too Many NET.CFGs -
• FTP Instead of SNADS -
• NetWare and IBM's DOS TCP/IP -
• Save your LAN Server/400 DCDB -
• Starting PC Apps from CL Programs -
• Running 16-bit ODBC Apps with 32-bit ODBC Drivers -
• Increase ODBC Prestart Jobs to Speed Connect Time -
• Improve ODBC Performance with SQL Parameter Markers -
• Add an AS/400 RDB Entry Before Using ODBC -
• Use QuerySystems, not IsRouterLoaded -
• Beware the Data Queue SetMode Function -
• Quick VARPG Part Renaming -
• Grow a VARPG Tree -
• Small Moves for VARPG Parts -
• Keep VARPG Parts Near Their Menus -
• Use VARPG's IPF Tags to Enhance 2nd-Level Help -
• Using Different Databases in a Visual RPG Application -
• Detecting the End of a Printed Page with Visual RPG -
• Export Your Application -
• Find the Last Day of the Month X Months from Now -
• Writing Portable Date Routines -
• When Is A - B + B <> A? -
• Displaying Dates -
• Sending Messages to QHST -
• Starting Up with a Menu -
• Restricting First-Level Folder Creation -
• Speeding Up Communications Applications -
• Deleting OV/400-Enrolled Users When OV/400’s Been Removed -
• Make Sure That Library's in the Library List -
• Copy Screen Doesn’t Have to Lag Behind -
• Damaged System Objects? Don’t Reload the Operating System Yet! -
• Determining When a DLO Was Created -
• Toggle Between Source and Comment Fields -
• Printing a Block of Lines -
• Validity Checking in DDS -
• Hints for Using CODE/400&’s DSU -
• Quick Tips for Aldon’s Flex/Powertools -
• Limiting Users with *ALLOBJ Special Authority -
• Where’s the File Member? -
• Cleaning Up Those Decimal Data Errors -
• Update Passwords on a Network Securely -
• 69 AS/400 Tips & Techniques, Part 2 -