iSeries Navigator: Application Administration

February 25, 2004 Shannon O'Donnell

One of the coolest things about OS/400 is its integrated security. If you are not the owner of an object, and that object does not have public access, and no one has granted you specific access to that object, guess what? There is absolutely no way you can get into it. Period. Show me any other operating system in the world that you can say that about.

The iSeries Navigator’s Application Administration tool allows OS/400 users who have sufficient authority in their user profile (*ALLOBJ, *IOSYSCFG), and have this piece of software installed on their PC, to control access to

Get Rid of the SNADS Headache with Auto-FTP

February 25, 2004 Wendy White

[The code for this article is available for download.]

Do you need a fast, reliable way to send code between iSeries boxes? With my Auto-FTP command, you can easily send code from PDM by setting up a user-defined option to do the work for you. It takes advantage of the iSeries’ powerful batch processing, as well as the ease of OS/400’s FTP utility.

Auto-FTP will automatically save the selected objects, transfer them to a remote system, and automatically restore them for you. If you haven’t used FTP before, you’ll quickly find it is one of the easiest

Is Your File Transfer Still Active?

February 25, 2004 Hey, Doug

Recently I was FTPing a large file from my AS/400 to a remote site. Upon returning from a long meeting, I found my 5250 session had locked up, and I had no idea of the status of my file transfer. I had to resend my file, which took hours. A colleague said there is a way on the AS/400 to check file transfers, but I could not find the command. Please help!

–Cathy

Great question, Cathy. This happened to me recently when I was required to send IBM a large file. Because of network issues, our local area network was

A Chicken-and-Egg Trigger Problem

February 25, 2004 Hey, Ted

Say I have two physical files: A and B. File A has an insert trigger program (written in RPG IV) that adds new records to B. That is, when someone adds a row to A, the trigger adds a row to B. What would happen if a program read B and added new rows to A?

insert into A (TransID, AnotherValue, Amount)
  select (TransID, AnotherValue, (0 - Amount) from B
     where substr(TransID,1,1) = 'T'

The intention is to zero-out the balances of all transaction IDs that begin with the letter T. That is, the sum of all records with a

OS/400 Alert: Security Starts At Home

February 25, 2004 Shannon O'Donnell

Everyone talks about security, but how many do anything about it? If you are looking for tools that will help you get a handle on the various security holes and vulnerabilities on your PC and AS/400, this issue of “OS/400 Alert” is for you. I’ll cover several tools that you can download and use to make your PC and AS/400 as secure as they can be.

MICROSOFT BASELINE SECURITY ANALYZER

Are you overwhelmed by the number of viruses and security holes spreading on the Web on a daily basis? Do you fear that you may not be able to keep