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

I had a reader email in relation to my article Paging Cursors. The article described a method for paging large lists using embedded SQL in RPG, and the reader was wondering if there was a way to position the list at a certain value. Of course there is!

Please refer to the original article for all of the gruesome details but the basic concept is that you have a subprocedure that returns a “page” of rows from a result set. A page can be any number of

I am writing in response to your article Dynamic Lists in Static SQL Queries. At a recent NEUSG meeting, Tom McKinley of IBM warned us to avoid temporary tables, especially query chains of temporary tables, as they have no history for the optimizer. I like dynamic SQL. I would have left it alone.

–Lynne

I always enjoy hearing from Lynne because I know I will hear words of wisdom. Lynne raises a good point that I have intended for some time to address in this august publication.

Kent Milligan, one of Tom McKinley’s colleagues at IBM’s DB2 for i

Enterprise Identity Mapping (EIM) is the technology that allows the IBM i to determine which user profile should be used to establish a connection for a person who has authenticated to an IBM i interface using non-IBM i credentials. EIM is easy to set up, but there is one thing you can do that will save you time and effort later.

A quick overview of EIM will help explain the tip. EIM consists of three categories of information:

1. EIM Identifiers representing people and entities (e.g., service userIDs) within the organization that have user IDs
2. User Registry Definitions representing the various