Discover how easy it is to view Windows and UNIX logs from one central console.

Written by Tom Huntington

As we automate more and more of the data center, we realize that just because something is automated doesn't mean that we will never have to deal with it again. Eventually, some of these automated tasks are going to fail. When they fail, you need to be able to view the logs for these events. You may need to sign on to the server, and you may need to provide reports to your management team, too.

What happens elsewhere is eventually going to affect you!

By Carol Woodbury

Good question. Why should you care what happens in Massachusetts unless you live there? The answer is because what happens in states such as California and now Massachusetts tends to spread to other states. The breach notification law started in California has spread to almost all of the states, and similar ones are being debated across Europe and Asia. If the Massachusetts privacy laws spread like the California law, you'll want to be prepared. Let's take a closer look. 

Rather than create multiple versions of code to do different things with data, this technique allows you to have only one copy of that logic.

Written by Kevin Forsythe

As we try to develop more modular code, one of the problems that we encounter is how to integrate modules or procedures that need to process more than a single record or row of data. We already know that we can easily pass parameters or arguments between procedures that hold all the data we need if we are processing only a single row or record. But what if we want to call a process that processes all the records for a selected part, or all the records for a given PO, or any similar process? What if we want to pass an array or multiple-occurrence data structure? Those have some limitations that make them more difficult to implement.

Have you been memorizing field names or relying on F4 prompting?

Written by Steven Goetjen

When creating file joins using interactive SQL (STRSQL), it's sometimes difficult to remember the field names that you want to join. I typically don't memorize field names and totally rely on the F4 prompting to get the names from the "SELECT fields" line.

Using authorization lists offers many advantages for those people charged with maintaining system and data security.

By Rafael Victória-Pereira

A well-structured authorization scheme that includes both user groups and authorization lists by application or library type allows for better control over the whole system, thus preventing unpleasant surprises and reducing the unauthorized-access risk.

Both a primer and a reference, this book is a must-have for anyone who wants to program in PHP.

By Mike Pavlak

After developing Web solutions for the iSeries in Net.Data and then getting a sour taste from Java, I wanted something better. PHP was certainly the right choice, but making it run on an iSeries at the time was no small feat. Then Zend came to the table, and the rest, as they say, is history. There is no way any of us on the ground floor of this amazing union could have anticipated this level of excitement and interest. We continue to see huge numbers being drawn to PHP on IBM i as well as Linux, UNIX, and Windows. And this book comes at just the right time; it's both a primer and a reference.

Is your BI solution hard to install and difficult to use?

By Floyd Del Muro 

Is your data out-of-date and your report backlog still a backlog? Is your BI technical department larger than two people, and do they spend most of their time redefining your data to make the solution work? Does your technical team spend hours upon hours installing program fixes? Does your solution work with only one database, and is it too complicated to allow end users to write their own inquiries? Do you have to pay more any time you want to do more? Is your BI solution meeting your needs?

If you're not properly using authorization lists, you could be in big trouble.

By Rafael Victória-Pereira

In Part I of this series, you learned what authorization lists are and what they do. Now,  let's consolidate all that information with an example.

Company X has a Human Resources application running on its system. Several users from different departments need to access the application for various purposes: