While using interactive SQL/400 from a green-screen session, I can direct the output of an SQL command to a database file. Is there a way to direct the output of a dynamically created SQL command to a database file from a batch job?

–Rich

Yes, you have a few options. First, let’s review the steps you use in your interactive session, for the benefit of the readers.

From the interactive session, press F13 to access the Services panel. From there select option 1 (change session attributes), and enter 3 at the SELECT output prompt. Fill in file name, library, and

I do a bit of development in Cygwin under Windows and then move it to the iSeries using Qshell. It turns out that Qshell doesn’t like the carriage-return/linefeed combination (CRLF) in shell scripts, so I often need to change CRLF to LF–as you wrote about in two previous articles–in bulk. Here are some methods I use to convert end-of-line delimiters in stream files.

The first method is a simple Perl command.

perl -i.bak -pe 's/rn/n/g' * 

This command adds the extension .bak to the end of the files and strips the CRLF, putting in LF instead. By using a wildcard,

There’s only one problem with using iSeries NetServer to deliver AS/400 Integrated File System (AS/400 IFS) file shares as networked Windows PC drives. The technique is so commonly used that it’s getting hard to find an easy primer for setting it up. As a service to the i5 community, this column focuses on setting up a NetServer environment from scratch on your i5, iSeries, or AS/400 partition.

What is iSeries NetServer?

iSeries NetServer (also called AS/400 NetServer in earlier versions) is an i5/OS and OS/400 server that enables Windows clients to access AS/400 IFS folders as mapped network drives. With

The System i platform has a powerful operating system, i5/OS. One example of that power is the fact that developers can tap into many features of the OS within homegrown applications by using the provided Application Programming Interfaces (APIs). Further, developers are allowed, via exit points, to create exit programs that interact with the system by responding to certain events that occur, such as when an FTP, SQL or Telnet request is made by a client application. This kind of versatility allows a developer to have fine-tuned control over a wide array of events on the system.

In this article,

The Integrated File System (IFS) continues to grow in importance in our shop. That means it also continues to grow in size. How can we determine which directories are largest when it comes time to clean them up?

–Dan

Use the Start Qshell (STRQSH or QSH) command to open Qshell. Use cd to navigate to any directory, then try this command.

ls -alsF | grep /$ | sort -r

Clear as mud, huh? Let’s look at it in detail. The ls command lists the files in a directory. In this case, the directory to be listed is the current directory.

After my recent article about duplicating data to a test environment, I started receiving e-mails discussing some other issues surrounding test environments and how your test data can affect (and be affected by) production data concerns. To address these concerns, I am going to pull back from the technical issues I usually discuss in this column and focus instead on the practical issues of designing an i5/OS test environment.

From my experience, I have found that a good i5, iSeries, or AS/400 test environment functions best when it is designed around the following four concepts:

• It should be secure