Setting Up an OS/400 HTTP Firewall Using Reverse Proxy

February 4, 2004 Shannon O'Donnell

If you are a regular reader of our technical articles, you should already be familiar with how to configure an HTTP Server on your AS/400 and how to serve Web pages. Of course, by exposing your AS/400 to the Internet, you are also increasing the odds that someone will attempt to hack it. One method you can use to secure your OS/400 from hackers is to set up an HTTP reverse proxy server on another AS/400. This article will show you how.

If you don’t remember how to set up an OS/400 HTTP Server, or how to store and serve

How Many Records Did SQL Delete?

February 4, 2004 Hey, Ted

I have an RPG IV program with an embedded SQL DELETE statement. Is it possible for my program to determine how many records are deleted when the statement executes?

–Tom

DB2/400 returns this information to you through a subfield of the SQL communications area (SQLCA), a data area that is automatically included in your RPG program when you compile. You can refer to this subfield by either of two names: SQLERRD(3) or SQLER3. When a DELETE, UPDATE, or INSERT operation completes normally, DB2 updates the subfield with the number of rows that qualified for the operation.

C/exec sql                              
C+             delete 

Recovering from WDSc Errors

February 4, 2004 Hey, David

I started using WebSphere Development Studio client (WDSc) a few months ago, and several times I caused it to crash. Twice now, a crash scrambled my Eclipse windows. The first time, I was able to get to the Eclipse update option off the help menu and the update fixed Eclipse. Yesterday, I accidentally double-clicked the WDSc icon in my startup tray and two copies of WDSc started running at once.

I shut down both copies and everything looked okay, but the next time I ran WDSc several windows were missing elements and contained empty frames with no data. One of

Admin Alert: Alternate Ways to Ensure a Subsystem Ends

February 4, 2004 Joe Hertvik

In “Three Common Mistakes in CL Administration,” I presented a technique for ensuring that a subsystem ends before processing other commands. However, several readers quickly spotted some errors in that technique and wrote in with corrections and suggestions on how to make that routine better.

To start with, I originally provided the following piece of CL code to end a subsystem, to copy and clear a file that is locked by that subsystem, and then to restart the subsystem:

ENDSBS SBS(SUB1)
MONMSG MSGID(CPF0000)

DLYJOB DLY(300)

CPYF   FROMFILE(LIB/CRITICAL) +
          TOFILE(LIB/CRITICALBK) MBROPT(*REPLACE) +
          CRTFILE(*YES)
MONMSG MSGID(CPF0000)

CLRPFM FILE(LIB/CRITICAL)

STRSBS SBSD(SUB1)
MONMSG MSGID(CPF0000)

OS/400 Alert: alphaWorks and Homeland Security

February 4, 2004 Shannon O'Donnell

In this issue of “OS/400 Alert,” we’ll tell you about some new electronic initiatives from the Department of Homeland Security. We’ll also alert you to some of the cool new tools, betas, trials, and emerging technologies from IBM’s bleeding-edge technology center, alphaWorks. IBM alphaWorks has consistently cranked out exciting new software technology, exceeding the output of any of the other major software skunkwerks anywhere in the world. In fact, many technologies being used today on the iSeries started as prototypes and became demos at alphaWorks.

NEW HOMELAND SECURITY NEWSLETTERS

The war on terrorism is about to hit your mailbox–at least