TechTip: Protecting Against Accidental Updates with Masked Values

DB2 for I 7.2 delivers a feature that can increase the integrity of your database.

kent milligan 117x117Written by Kent Milligan

With the intense focus on data privacy, many applications are being modified to protect the personal data that they are processing. Masking is a data protection technique that's commonly being deployed so that the vast majority of application users are allowed to see only a masked version (############1234) of sensitive data values, such as credit card numbers. Access to the original card number value is limited to a select set of privileged users.

TechTip: I Wrote My PJL Script, So Now What Do I Do?

Sometimes you need to do complex things with your prints, and PJL is one way to get it done. But how do you incorporate a PJL script into an i job stream?

david shireyWritten by David Shirey

As explained in my previous TechTip, Printer Job Language (PJL) allows you to control how the printer reacts to jobs you submit. Now the truth is that many printers will automatically figure out what the heck is going on, but not all will. As you try to use many different types of printers to carry out your assignments, you may find yourself in need of the ability to tell the stupid printer what to do. A good example might be if you wanted to add a copier to print output from the IBM i.

Import CSV Files with File Correcting

Build your own user-friendly CSV file-upload programs.

rafael victoria preiraWritten by Rafael Victoria-Pereira

Editor's note: This article is an excerpt from the new MC Press book Flexible Input, Dazzling Output with IBM i.


This chapter presents a user-friendly CSV file upload program. While the program itself is simple, it uses some interesting procedures to recover records with the most common user errors in the CSV file. In

The API Corner: Getting Directions Using Inquiry Messages

Use APIs to send and receive messages.

bruce viningWritten by Bruce Vining

Last month, in Trying to Allocate an Object?, we enhanced the program AllocObj, which was first introduced in Problems Allocating an Object?. The enhancement was that the program, if run in an interactive job, would build a subfile listing those jobs with locks on the object. From this list, the user could decide to contact someone about one or more of these jobs, end one of more of these jobs, and/or cancel the current running of AllocObj.


This month, we are going to look at the batch side of AllocObj.

In the Wheelhouse: IBM, We Have an SSL Problem

In the spirit of last week's article regarding IBM's on-premises intentions for IBM Mail Next, we need to simplify and fix Domino SSL. It's going to break.

steve pitcherWritten by Steve Pitcher

A few months ago, I renewed my wildcard SSL certificates from GoDaddy.com and began the process of updating both types of HTTP servers in my shop: IBM HTTP Server and IBM Domino. I usually do Domino first and then IBM HTTP Server, the latter of which is a bit of a struggle. I'll get to that.


Updating Domino is always a journey as it involves importing a new certificate into the Domino keystore and then updating the existing proprietary *.kyr key file in my primary Domino server's data directory.



Susan Gantner Shares New "Favorite RSE Keyboard Shortcuts" Tip Sheet

Free download now contains Debugger shortcuts and tips.

HelpSystems Improves Web Interface of Its InterMapper Network Monitoring Software

The newest version of InterMapper includes 64-bit support and a responsive web interface.

Kenexa on Cloud Learning Solutions Provide an Open, Flexible, and Resilient Platform for Learning

IBM Kenexa Learn on Cloud solution enhancements can help organizations rapidly develop, deploy, and increase workforce skills and learning capabilities.

Alliance Key Manager Now Available on AWS Marketplace

Alliance Key Manager for AWS provides encryption and key management to help Amazon Web Services customers meet data privacy compliance regulations and security best practices.

ESSL V5.3 Offers Additional Subroutines and Supports New IBM Power Systems Built with POWER8

IBM Engineering and Scientific Subroutine Library (ESSL) for AIX and ESSL for Linux on Power add 81subroutines and support for Power Systems built with POWER8 technology.

Using the IBM Advanced Job Scheduler for i

Manta announces the availability of a new course covering the IBM Advanced Job Scheduler for i, or AJS, a batch scheduling facility that is available with IBM i at no additional charge.

Kisco Announces Release 2 for End-User Password Reset Utility for IBM i

Kisco Information Systems announces a release upgrade for its browser -ased, end-user password reset tool for the IBM i platform of computers.



Configuring IBM i iSeries Access Server to Use SSL

To see a list of all the MC Press videos, click here


Fri Aug 22
2014 IBM Systems Technical Symposium

Events Calendar

August 2014
27 28 29 30 31 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6



<< NEW BOOK >>

DB2 10.1 Fundamentals: Certification Study Guide

"Too valuable to be classified as merely excellent certification material, this book should also rightly take its place on DB2 DBA bookshelves as a solid day-to-day DB2 reference" says Rebecca Bond.
Read her Book Review: DB2 10.1 Fundamentals: Certification Study Guide



See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:


  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 


Watch the Webinar Now!



MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.


Latest Titles >>

eBook Special >>



Shop the MC Press Store