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.

Technology Focus: Content Management Isn't Just About What's in Your Docs Anymore

But for most IBM i users, the emphasis on document content is hard to escape if you're looking at apps that run directly on the i.

john gristWritten by John Ghrist

Content management as a product type across IT in general is conceptually divisible into two main categories: document content management and Web content management. When it comes to focusing on that product type more specifically in the IBM i market, though, content management takes on a more sharply document-centric tone.

Security Patrol: The Hidden Dangers of Shadow IT

Carol discusses the dangers of allowing IT projects outside of the IT team and the problems doing so can present to your organization.

carol woodburyWritten by Carol Woodbury

I've heard them called by several terms"rogue IT", "super users," and most commonly, "shadow IT"but essentially it's those users who perform duties that would normally be done by traditional IT staff…but these workers don't work for IT. Often, these workers have a background in IT, having moved from a position in IT to a position on the business side of the organization. They think that since they know how to perform these tasks (writing queries, replicating databases, developing complex spreadsheets, etc.), they might as well do the work. No harm, right?



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.

Software AG Demonstrates Market Leadership in Application Integration Again

Gartner names Software AG a leader in Magic Quadrant for on-premises application integration suites.



Configuring IBM i iSeries Access Server to Use SSL

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


Thu Aug 21
2014 IBM Systems Technical Symposium
Thu Aug 21 @13:00 - 03:00PM
Power 7 & 8: IBM i Trends & Tech Tour - Seattle, WA

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