A customer recently reported a bug in my SQL Thing product, but after investigation it turned out not to be a bug but the user’s perception of how decimal arithmetic works in the i5/OS operating system. The user was doing some arithmetic with decimal fields and then multiplying by 100 to show the value as a percent, and was getting a result of zero for all of his calculations.

The real problem is in the way the AS/400, iSeries, and i5 handle promotion of precision and scale when decimal numbers are used in equations. If you are not careful,

Is there an OS/400 command that will let me append one stream file to another? I checked the Copy Object (CPY) command, but it only has a REPLACE(*YES/*NO) parameter, unlike Copy File (CPYF), which supports MBROPT(*REPLACE/*ADD).

–Bruce

This question was posted on the IT Jungle Forums. It seems odd that there is no direct method using CL commands to append one stream file to another. Chris gave examples of two methods that do the job.

The first is to use Qshell’s >> redirection operator, which appends output to the destination file. Here’s how it would work in a

In a recent column, I covered how to use iSeries Navigator’s Run Command feature to submit batch i5/OS commands to an i5 system for execution. This week, I will cover some additional configurations that will help you set up other Run Command options, as well as to determine whether a specific batch command can be submitted for execution by Run Command.

Run Command is a valuable OpsNav feature that allows you to graphically enter and send batch i5/OS commands to an i5 partition for execution (see Part 1 of this article for basic information on how to use Run