Reusing HTML and Form Filling with RPG CGI
by Shannon O'Donnell

In "Step by Step: RPG IV and Interactive Web Pages" I demonstrated how easy it is to use your RPG skills to push content out to a Web browser. The Web pages displayed in the article were built from within the RPG IV code. This article explains how you can reuse HTML documents in an RPG CGI program. You will also learn how to pre-load HTML form fields from RPG before displaying the document in the browser. READ MORE >

Using DRDA to Execute SQL Statements on Another iSeries
by Michael Sansoterra

For iSeries shops using SQL with multiple machines or logical partitioning, IBM's Distributed Relational Database Architecture (DRDA) may help with SQL administration tasks. For example, it is common to develop an SQL routine on a test box and then duplicate the routine on a production box, which requires a cut and paste of SQL text or some other mechanism to propagate the routine. Or, sometimes it may be handy to know what's in a file on the live system while working on the test system, without having to go through the pain of starting a new 5250 session or using iSeries Navigator. READ MORE >

  Admin Alert: Finding More Elusive OS/400 Commands
  by Joe Hertvik

In my last column, I discussed several ways to find and execute OS/400 green-screen commands, even when you don't know the exact spelling of the command name. While I covered three different ways to find elusive OS/400 commands--using the Major Command Groups menu, the Select Command (SLTCMD) command, and the Verb Commands menu--several readers wrote in to tell me about a few other tricks that accomplish the same thing. Here's what I learned. READ MORE >

Reader Feedback and Insights

We value your feedback and insights. Feel free to send a letter to the editor. Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >

Advanced Systems Concepts
COMMON
Guild Companies