The SQL Script Center, which is part of the System i Navigator Database function, allows the user to execute a script that contains single or multiple SQL statements. If the script contains multiple SQL statements, the user has the option of executing a single SQL statement, the entire script (starting with first statement in the script and ending with the last statement in the script) or two or more consecutive SQL statements as a subset of the script.

The results from executing an SQL statement are shown in the lower portion of the Run SQL Scripts window called the Output

My life was confusing enough already. Then along came IBM with binder language, the CL-like language we use to define the list of exports of a service program. Awhile back I sat down to try to find an effective way to deal with service program exports. Here’s what I came up with.

When you create a service program, you must list the exports, that is, the data and/or modules that are available to callers. There is a shortcut. If you specify EXPORT(*ALL) in the Create Service Program (CRTSRVPGM) command, the system will generate the list of exports for you. However,

We recently added a second IP interface to one of our i5/OS partitions. After an IPL, the partition stopped talking to Internet-based trading partners. It stopped trading FTP files with outside vendors, it wouldn’t relay email, and it generally stopped talking to the outside world. This week, I’ll look at the common problem that took down our Internet communications and how you can stop it from happening in your shop.

A Case Study in Configuring for Multiple IPs

After the configuration change, we had two IP interfaces on our partition: one for all our normal IP traffic (10.3.1.55); and a