We’ve made it through another year. I hope it’s been a good one for you in spite of the hardships and challenges. Let’s read some of the feedback that I received in 2015 and see what we can learn.

Hey, Ted:

To make a grep search case-insensitive, use the “-i” switch. I also add the “-n” switch to show the line number.

catsplf -j 681206/MYSELF/MYJOB QSYSPRT 1 | grep -in 'smith'

I also have a SCANSPLF command. It is not case insensitive, but that would not be hard to implement.

Keep the great articles coming.

–Bryan

Bryan wrote in

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

CSV (comma-separated values) files have been part of my working world for years. I like them because they’re easy to build. Users like them because they can easily open them in Microsoft Excel. I’ve written about this before. Let’s end the year with a utility I wrote to print CSV files. I had fun writing it. Maybe you’ll find it useful in your shop.

When I need to read a CSV file on an IBM i system, I typically FTP the file from the IFS to a temporary

An ETL process extracts data from our ERP system and places it in our Business Intelligence systems. It runs 24/7 except for the End of Day process that shuts down the subsystem that it’s in. The SQL process we run ends up dying violently and the parent process fails (without recovering on startup). A graceful exit would be as simple as issuing a RETURN statement! Can SQL detect a shutdown process?

–D.S.

The ANSI SQL standard offers no specific guideline for implementing some kind of host shutdown process, so you’ll have to rely on the other special OS related views