Query Active Directory from the iSeries

June 15, 2005 Michael Sansoterra

The code for this article is available for download.

With respect to iSeries programs, real time integration with other platforms and databases has been one of my favorite pursuits. Unfortunately, as a consultant, I perceive that many have left the iSeries because of the perception that certain things could not be done programmatically. Of course, with the addition of Java and the APIs available to the ILE programmer, we know that the iSeries can do about anything–sometimes you just have to dig a little to find out how. In this article, I’m going to discuss a technique to query

Fetch a Variable Number of Records with SQL

June 15, 2005 Hey, Ted

If you want to use a variable for the number of rows to fetch in an SQL query, there is an alternative to the FETCH FIRST n ROWS technique you presented recently in Four Hundred Guru. Here is some code from an SQLRPGLE program shell I have used since V5R1. It uses a cursor instead of placing the number of rows directly into the SELECT statement.

c/Exec SQL                                         
c+ Fetch from C1 for :NbrRows rows into :RtnDtaSet 
c/End-Exec

–Rick

Rick’s comment is in response to the last paragraph of the issue he refers to. His idea is to use

Admin Alert: A Quick Audit of Your IPL Parameters

June 15, 2005 Joe Hertvik

Being a mature operating system, i5/OS V5R3 (as well as several earlier versions of the OS/400 operating system) contains a number of system values that determine when, where, and how your system can be IPLed. As such, it’s worth performing a mini-IPL audit every once in a while just to familiarize yourself with the system’s IPL options as well as to insure that your IPL configuration meets your shop’s needs.

Inside i5/OS, IBM allows you to configure rules about your IPL strategy through a number of IPL-related system values. On the green screen, these values can be located and modified