Note: The code accompanying this article is available for download here.

I am trying to secure external access to our iSeries DB (ODBC, JDBC, et al). From a security point of view, I want to allow database access if it comes from specific IPs or servers. But I cannot find a way to identify the source (i.e., remote IP address) from the QIBM_QZDA_SQL2 exit point. I only find the user ID. Is there a way to obtain the source of the remote client attempting to connect to DB2?

–Mike, Four Hundred Guru Reader

Hi, Mike:

You are correct. The

I want to build a temporary database file to send to a user, but records with a zero divisor do not get written to the output file. Can I prevent Query for i from dividing by zero?

–Bill

Yes, Bill, and it’s not difficult. Here’s how it’s done. But first, some test data.

create table mylib/divbyzero
(Extended dec(5,2), Qty dec(3,0))

insert into mylib/divbyzero values
(500, 2), (0, 12), (6, 0), (0, 0), (100, 3)

Now I have five rows of data to play with, two of which have zero in the Qty field. Here’s my first attempt to create an

Great article on six tips for preventing Power i upgrades from slowing down. One tip that you missed is using Image Catalogs for your upgrades. They really help with installing software and PTFs. Also PTFs should be downloaded via FTP using IBM procedures from their Web site. CDs and DVDs are nice, but image catalogs are significantly better!

–Rich

Rich wasn’t the only reader who pointed out the advantages of using Image Catalogs in lieu of CDs or DVDs for i/OS PTF application and upgrades. While I neglected to mention them in my recent article, image catalogs can be