• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Admin Alert: What Should An IBM i Administrator Do, Part 1

    December 3, 2014 Joe Hertvik

    With remote monitoring and lights-out data centers, people think there isn’t a need for system operators any more. And they’re right-ish. There’s little need for low-skill operators whose main function is watching the system and printing reports. But IBM i operations work isn’t obsolete; it’s just changed into a systems management function. Given that, here’s my take on tasks a lower level IBM i system administrator can perform in 2015 and beyond.

    Why You Need Day-To-Day IBM i Administrators

    For IBM i shops, it’s important to define the difference between project management and day-to-day operations. IBM i project managers are

    …

    Read more
  • TR8 DB2 For i Enhancements, Part 1

    November 12, 2014 Michael Sansoterra

    IBM i 7.1 Technology refresh 8 was released on June 6, 2014, and it has another group of small database enhancements worth reviewing. IBM i 7.2 users will find that they already have these features. This tip assumes that you have IBM i 7.2 or IBM i 7.1 with Database Group PTF Level 29 or higher installed.

    QSYS2.GENERATE_SQL Stored Procedure

    This is one sweet new stored procedure IBM has given us. Its purpose is to programmatically retrieve SQL source code into a source member.

    This procedure can accept a boatload of parameters as shown below. Many of the parameters control

    …

    Read more
  • SQL Functions You Didn’t Know You Had, Part 2

    November 12, 2014 Ted Holt

    In SQL Functions You Didn’t Know You Had, Part 1, I showed you how to make an SQL function that runs a subprocedure in a service program. What I showed you is fine up to a point, but it’s not the entire story.

    The technique that I shared with you breaks down when null values enter the picture. First, the subprocedures in the ADDR service program cannot accept null arguments into parameters. Second, those subprocedures cannot return a null value to the SQL query.

    These behaviors are specified in two clauses of the CREATE FUNCTION statement:

    • PARAMETER STYLE GENERAL
    …

    Read more
  • Flip This Job Number: Adjusting The Job Queue Control Utility For Job Number Resets

    November 12, 2014 Hey, Joe

    I just read your article on creating a skeleton program for controlling IBM i job queues creating a skeleton program for controlling IBM i job queues. In your job queue physical file (WRKJOBQPF) that contains the list of jobs inside a specific job queue, you keyed that file by the six-digit job number of each job in queue. I think that’s a bad idea. Here’s why. . .

    –Charles

    Charles continues:

    “On busy systems where the job number can flip (over to 000001) daily, it introduces a period of time where the results will not be desirable. Needless to

    …

    Read more
  • SQL Functions You Didn’t Know You Had, Part 1

    October 22, 2014 Ted Holt

    What if I told you that you may have some potential powerful SQL functions on your system that you are not aware of? What if I told you that I have no idea what those SQL functions are named? What if I told you that you could easily use existing RPG routines in SQL queries? Would you be interested?

    (Take a tip from the Little Rascals (AKA Our Gang) and say, “And how!”)

    It’s easy to make SQL functions out of the subprocedures in service programs. To illustrate, here’s the source code for an RPG module from which a service

    …

    Read more
  • Paging Cursors

    October 22, 2014 Paul Tuohy

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

    I would like to share with you one of the techniques I use for paging large lists when using embedded SQL in RPG. This method came about when I needed to write a routine which could be used in both an interactive (green screen) and web environment. There were two main challenges:

    • The size of a “page” could vary. This was easy enough to handle, I just had to decide what the maximum page size would be.
    • The web interface would not be persistent. This meant that different
    …

    Read more
  • The IBM i *LOOPBACK Interface Problem

    October 22, 2014 Hey, Joe

    Help! My IBM i credit card software stopped talking to our outside credit card processor. One minute it was working, and the next minute it crashed. When I restart the package, it immediately ends. What’s going on? We can’t process our orders.

    –Henry

    This is an unusual situation I’ve seen every once in a while, and it usually involves your TCP/IP setup.

    Troubleshooting The Issue

    The first thing to look at is whether all your TCP/IP interfaces are up and running, and whether anything changed with your TCP/IP setup. Before you call your software provider or IBM, check the

    …

    Read more
  • Find A View Of A View Of A View. . .

    October 8, 2014 Paul Tuohy

    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

    …

    Read more
  • A Bevy Of BIFs: Updates

    October 8, 2014 Jon Paris

    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

    …

    Read more
  • Admin Alert: A Skeleton Utility Program For Controlling IBM i Job Queues

    October 8, 2014 Joe Hertvik

    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
    …

    Read more

Previous Articles Next Articles

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • POWERUp 2025 –Your Source For IBM i 7.6 Information
  • Maxava Consulting Services Does More Than HA/DR Project Management – A Lot More
  • Guru: Creating An SQL Stored Procedure That Returns A Result Set
  • As I See It: At Any Cost
  • IBM i PTF Guide, Volume 27, Number 19
  • IBM Unveils Manzan, A New Open Source Event Monitor For IBM i
  • Say Goodbye To Downtime: Update Your Database Without Taking Your Business Offline
  • i-Rays Brings Observability To IBM i Performance Problems
  • Another Non-TR “Technology Refresh” Happens With IBM i TR6
  • IBM i PTF Guide, Volume 27, Number 18

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle