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

SQL’s Data Definition Language (DDL) offers many great features, one of which is the ability to define a view of a view. This can lead to simple or complex structures making use of views of views of views of. . . you get the idea.

But one of the difficulties with this technique is that, once created, it is difficult to determine the depth of dependencies for views. The Display Database Relations (DSPDBR) command will tell you which views are immediately dependent on a view but it will

In my last tip I returned to the “Bevy” series to tell you about the latest addition to the family: %ScanRpl. Shortly after completing that tip I realized that there have been a number of more recent BIFs such as %SubArr and some enhancements to existing BIFs like %Trimx that seem to have escaped people’s notice. In this tip I attempt to fill those omissions.

%Trim: Specify Characters to Trim

Let’s start with a BIF that hopefully you are all familiar with: %Trim. Before going any further I should point out that when I say %Trim, I am referring to

From an IBM i operations viewpoint, there are several scenarios where you need to automate job queue management. Situations where you may have to automatically change one or more parameters for a job waiting in job queue include:

• Looking for a specific job and automatically moving it to another job queue.
• Moving all jobs in queue to a different job queue when they are held up behind a slow-moving job or a job waiting for a reply in batch.
• Rearranging or changing job priorities so certain jobs run before or after other jobs.
• Detecting an excessive number of jobs in