A Generic Command Choice Validity Checker

October 6, 2004 Bruce Guetzkow

The code for this article is available for download.

In my previous article I created a generic program that you can use to display command parameter choices that are stored in a file: a command choice program. While that program is very useful, it is only part of the story. This time I’ll show you a procedure and service program that you can include in a validity checking program to ensure that parameter values entered are valid. With this second part, you will be able to validate parameter entries based on values stored in a file.

THE VALIDITY CHECKING

Conditional Sorting with SQL

October 6, 2004 Hey, Ted

We are a small business in Ohio. Most of the people we do business with are also in Ohio. Is there a way we can retrieve a list of clients with the Ohio clients listed first, followed by all others, in order by state?

–William

SQL/400 can handle this task for you. Use a CASE structure in the ORDER BY clause.

select custnbr, custname, ccity, cstate
  from customer
 order by 
   case cstate when 'OH' then 0 else 1 end,
   cstate, ccity

The first sort field is a case expression. For records that have a state value of OH, this

Admin Alert: Make User Profiles Go Cross-Partition with OpsNav

October 6, 2004 Joe Hertvik

The iSeries Navigator (better known as “OpsNav”) has a lot of nice hidden features that make life easier for administrators. One valuable feature is that you can use OpsNav for propagating OS/400 user profiles from one i5, iSeries, or AS/400 partition to another, while retaining the same profile information in each environment. Here’s how you do it.

First, if you are going to use OpsNav to transfer user profiles (or other OS/400 objects, such as libraries) between different systems, you need to have a Management Central network set up that connects all your different AS/400, iSeries, and i5 machines. Management