• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Journal Forensics 101

    March 6, 2013 Steven Wolk

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

    A good friend of mine, who also happens to be president of our local user’s group, had been encouraging me to present a session at one of their meetings. I resisted for some time, but finally decided this was an exciting prospect. The topic I would choose became clear to me almost immediately. We use journaling in my shop for so many purposes that we simply couldn’t survive without it. I’ve always been very interested in journaling, especially in applications of the technology to forensics and recovery.

    It’s

    …

    Read more
  • When Who Did What

    March 6, 2013 Ted Holt

    When you create a new database table (physical file), you should include those columns (fields) that are fully functionally dependent on the key fields. I would like to mention some additional columns that you might like to include also.

    The columns to which I refer are ones that store creation and change data. For example, you may want to be able to tell who inserted a row (added a record) and who last changed it. Such information may allow you to give a quick answer to a user’s conundrum.

    Look at this simple CREATE TABLE statement. Notice the last six

    …

    Read more
  • Admin Alert: A Checklist For Moving Power i Partitions To A Different Location

    March 6, 2013 Joe Hertvik

    With corporate buy-outs, company spin-offs, and moving Power i servers to a centralized data center or a managed server provider, many shops are finding that they need to move their Power i partitions to a different network or a cloud provider. To that end, here’s a checklist I put together to help ensure that your Power i partitions can function without issue in a new environment.

    Why We Move

    There are many reasons you might need a playbook for moving a Power i partition from one location and network to another. Some of the more common situations include:

    • Company sale
    …

    Read more
  • Stored Procedure Parameter Defaults And Named Arguments In DB2 For i

    February 20, 2013 Michael Sansoterra

    Starting with IBM i 7.1 Technology Refresh 5, DB2 for i stored procedure parameters support a default value, and the CALL statement supports named arguments. (DB2 for i Group PTF Level 18 or higher provides this new functionality). These simple and related enhancements can have surprising benefits for code comprehension and code maintenance.

    Let’s look at creating a procedure with one or more parameters having a default value:

    CREATE PROCEDURE DEV.CREATE_ORDER (
    IN @CUSTOMER_ID INT,
    IN @ORDER_DATE DATE DEFAULT CURRENT_DATE,
    IN @ORDER_ID INTEGER DEFAULT (NEXT VALUE for DATALIB.ORDER_ID_SEQUENCE) ,
    IN @ORDER_SOURCE VARCHAR(10) DEFAULT 'WEB') 
    LANGUAGE SQL
    BEGIN
    …
    END
    
    …

    Read more
  • New CL String-Handling Functions

    February 20, 2013 Ted Holt

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

    I love it when IBM enhances CL. When I hear of a new feature, my first thought is, “What can I do with this?” My mind has been spinning since Guy Vig first told me about CL’s new string-handling functions a few weeks ago. Let me tell you about these functions and some of the uses for them that have already occurred to me.

    First, here are a few facts you need to be aware of:

    • IBM delivered the new functions in two PTFs: SI49061 and SI48166.
    …

    Read more
  • Getting Short-Term Maintenance For Your Power i Machine

    February 20, 2013 Hey, Joe

    I purchased a three-year maintenance contract when I bought my Power7 machine in 2010. The contract runs out in May but I need extended maintenance through July when I’m installing a new machine and returning the old machine to the leasing company. How do I extend my hardware/software maintenance for only two months without having to buy a one-year maintenance contract?

    –Jean

    This is a fairly common situation and one that IBM provides an out for in their maintenance contracts. Here’s how you can sign a one- or multi-year maintenance contract for your existing machine and then cancel the contract

    …

    Read more
  • What’s That Name, Again?

    February 6, 2013 Paul Tuohy

    One of the great things about writing articles and tips is that people will drop you a note to ask a question or tell you how much they liked (or disliked) what you wrote. But even better is when someone drops you a line to let you know they have taken what you wrote and extended it.

    Such was the case with my last tip, What’s That Name?, which described how to go about getting a “record layout” in Run SQL Scripts. I received an email from Lynne Noll, who said she had just written 128 stored procedures, and

    …

    Read more
  • Don’t Clone That Printer File!

    February 6, 2013 Hey, Ted

    I have a program that uses an externally described printer file to create a report. I need to change the program so that it writes some information to one spooled file and the remaining information to a separate spooled file. I could clone the printer file, but that would mean I’d have to change two files instead of one when I modify the report file in the future. Do I have to clone the printer file?

    –Mark

    No, Mark, you can build two or more reports from one printer file definition. Here’s how it’s done.

    Let’s start with a printer

    …

    Read more
  • Admin Alert: When Was The Last Time That Library Got Backed Up And More

    February 6, 2013 Joe Hertvik

    This week, I’ll cover some new information about IBM i library backups, tell you how to specify which TCP/IP servers start whenever TCP/IP is started, and demonstrate a second technique for preventing unauthorized FTP access to your server. Let’s get started.

    Determining The Last Time A User Library Was Backed Up

    Checking the last time a user library was backed up is easy. You can check it from the green-screen by running the following Display Library Backup List (DSPBCKUP) command.

    DSPBCKUPL BCKUPL(*LIB)
    

    This command will display a screen that looks something like this.

    Figure 1

    (Click graphic to enlarge.)

    This

    …

    Read more
  • Dealing With Library Lists In RSE/RDP

    January 23, 2013 Susan Gantner

    I’m happy to say that I’m hearing from more and more people who are beginning to finally break away from SEU to use Remote Systems Explorer (RSE) in Rational Developer for Power Systems (RDP). Perhaps the fact that IBM finally stopped updating SEU for new language features as of V7.1 has caused more shops to consider the move.

    I heard from one newbie RSE user the other day with fairly common issue; he wanted to know how to deal with library lists in the RSE environment? In his case, he has a few different library lists due to various packages

    …

    Read more

Previous Articles Next Articles

Content archive

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

Recent Posts

  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24
  • Big Blue Raises IBM i License Transfer Fees, Other Prices
  • Keep The IBM i Youth Movement Going With More Training, Better Tools
  • Remain Begins Migrating DevOps Tools To VS Code
  • IBM Readies LTO-10 Tape Drives And Libraries
  • IBM i PTF Guide, Volume 27, Number 23

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