• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • The New Basics: Indicators

    September 19, 2012 Jon Paris

    The history of indicators pre-dates even the earliest versions of RPG and takes us all the way back to the old tabulating machines, perhaps even earlier depending on how broad a definition one uses. What is without doubt, though, is that indicators in the sense of *INnn and *INLR were introduced to the RPG language as a vehicle for translating those old tabulator board programs.

    RPG has grown a lot since those early days, and yet many people still write code using the old-style numbered indicators. LR? Well, we’re kind of stuck with that, but there hasn’t been a need

    …

    Read more
  • Admin Alert: Two Useful PC5250 Parameters In IBM i Access For Windows 7.1

    September 5, 2012 Joe Hertvik

    With IBM i Access for Windows 7.1, IBM offers some valuable parameters for customizing Personal Communications sessions (PC5250) to connect to your IBM i partitions. This week, I’ll look at two of these features–setting a default path for PC5250 configuration files; and storing PC5250 window and font information–that can be useful for IBM i administrators trying to provide better control over their user installs.

    For this article, I’ll discuss two valuable PC5250 configuration parameters that are available with IBM i Access for Windows 7.1. These features are configured through the IBM i Access for Windows Properties screen, which is accessed

    …

    Read more
  • Future Coding

    September 5, 2012 Paul Tuohy

    One of my favorite benefits that comes from speaking at conferences is the great questions that get asked of me and other speakers. Even if we can answer the question, be assured the next time we’re gathered with colleagues over a cup of coffee (or other beverage of choice), one of us will say, “I was asked an interesting question at my last conference. . .”

    At the last RPG & DB2 Summit, I was having coffee with Susan Gantner and Barbara Morris, when Susan uttered those intriguing words. The ensuing conversation didn’t result in a change to the answer

    …

    Read more
  • Checking IBM i OS and PTF Level Status for Sarbanes-Oxley Documentation

    September 5, 2012 Hey, Joe

    I have to write a quarterly procedure for our Sarbanes-Oxley manual that details how we make sure our IBM i operating system and PTFs are current. Our auditors want us to prove that we are up to date on upgrades and fixes. Any ideas on how we can do that? I’m on i 6.1.1.

    –Bill

    Here are my thoughts for doing this on a 6.1.1 system. Note: The process I’m describing here can be used to provide operating system and PTF review documentation for any auditing requirements, not just SOX.

    Review your PTF and upgrade status at least twice yearly

    …

    Read more
  • Admin Alert: Copying User Profiles Between Systems

    August 22, 2012 Joe Hertvik

    There are times when IBM i administrators may need to copy a user profile from one IBM i system to another, especially when promoting software from a development to a production system. This week, I’ll illustrate three different techniques for copying profiles between systems and talk about their strengths and weaknesses.

    Three Ways To Copy User Profiles Between Systems

    There are three different ways that I know of to copy a user profile between IBM i operating systems. These techniques are ranked here in terms of the most difficult way to the easiest way to copy a user profile.

    1. Manually
    …

    Read more
  • Where’s The Module?

    August 22, 2012 Susan Gantner

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

    Over the years I have participated in many discussions about how to find all the programs that have a specific module bound into them. Since the DSPPGM command doesn’t support output to a file, it provides a challenge to find this information. The question always seems odd to me, because my philosophy is that if the code in a module is needed in more than one program, it goes into a service program. The service program is then referenced by (and shared by) all the programs that need

    …

    Read more
  • Composing An XML Document From Relational Data: Part 2

    August 22, 2012 Michael Sansoterra

    In Part 1 of this series, I covered how to transform the results of a DB2 for i7.1 query into either an element- or attribute-based XML document. This time, I’m going to delve into a more complicated XML composition that requires the nesting of sales order XML elements as children of retail store elements. As with the last tip, I’ll start with a base SQL statement that extracts the required data and then gradually transform that statement until it produces the desired XML document using the new DB2 for i XML functionality.

    To start, here is the base query that

    …

    Read more
  • Admin Alert: The Right Way To Delete User Profiles, Part 2

    August 8, 2012 Joe Hertvik

    Last issue, I introduced a two-part article discussing techniques for deleting user profiles. Part one focused on prepping a user profile for deletion. In part two this week, I discuss how to determine whether the user is a critical user and what to do about it, and I demonstrate three techniques for deleting users. After reading both articles, you will have a good template for creating an IBM i user deletion procedure in your organization.

    The Five Steps Of User Deletion

    Last issue, I introduced a template that determined the best way to deal with terminated IBM i users

    …

    Read more
  • Composing An XML Document From Relational Data, Part 1

    August 8, 2012 Hey, Mike

    My boss asked me if I know of a cheap or free tool that can automatically export a DB2 (for i) table to an XML file. I told him that I could write a Java program pretty easily that could accomplish this for a specific table, but I’m not aware of any way to “generically” do it for any table.

    For example:

    select *
      from deleteme
    
    TheKey   SomeText
         1   Row Number 1
         2   Row Number 2
    

    That code should produce output something like this:

    <?xml version="1.0" encoding="UTF-8" ?>
    <deleteme>
     <row>
       <TheKey>1</TheKey>
       <SomeText>Row Number 1</SomeText>
     </row>
     <row>
       <TheKey>2</TheKey>
       <SomeText>Row Number 2</SomeText>
     
    …

    Read more
  • Accessing Multiple DB2 Relational Databases In A Single Query

    August 8, 2012 Michael Sansoterra

    In my prior tip, I covered a new feature provided in the i7.1 technology refresh 4 update that allows a INSERT/SELECT statement to insert data into a local DB2 for i table from a query against a remote DB2 database. In this tip, I will cover a method that can be used to query multiple DB2 relational databases in a single statement.

    Author’s Note: Incidentally, the remote DB2 database can be another member of the DB2 family besides DB2 for i. Check out my article on DB2 for Windows for more information.

    As I mentioned in my last tip

    …

    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