Reusing HTML and Form Filling with RPG CGI

September 1, 2004 Shannon O'Donnell

The code for this article is available for download.

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.

For an RPG CGI program to be truly useful, you really have to

Using DRDA to Execute SQL Statements on Another iSeries

September 1, 2004 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

Admin Alert: Finding More Elusive OS/400 Commands

September 1, 2004 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.

Jerry Thornton and Ben T. Ray Jr. pointed out that you can get to the various command submenus listed on the Major Command Group, Subject, or