• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Presenting Vertical Data Horizontally

    July 10, 2013 Victor Pisman

    Presenting “vertical” data in a “horizontal” format is a challenging task in data management. Here is one method you can use to make SQL carry out this type of transformation.

    Consider table CUSTGRP, which has two fields: a customer ID and a group code. Notice that one customer can have multiple group codes.




    ID

    ID

    GROUP

    100

    C

    100

    F

    100

    D

    200

    A

    200

    E

    200

    D

    500

    G

    700

    B

    700

    D

    Here’s one way to

    …

    Read more
  • First Normal Form On The Fly

    July 10, 2013 Ted Holt

    Converting normalized data into a repeating group is a common requirement, and we have discussed that topic several times in Four Hundred Guru, even in this issue. Sometimes the need arises to convert data in the other direction, i.e., to convert a repeating group to a normalized form. This is a handy technique to know, and it’s easy.

    Suppose you’ve been given a spreadsheet with 13 columns of data. The first column is an item number. The next 12 columns are replacement costs for each month. You’ve been asked to load the data into a normalized table (physical

    …

    Read more
  • Admin Alert: Major And Minor IBM i Power System Upgrades

    July 10, 2013 Joe Hertvik

    When upgrading your current IBM i hardware, you may have more choices than you think. With the incredible capacity built into late model System i and Power systems, you may be able to perform a minor upgrade on existing hardware, rather than moving to the latest Power 7+ machines. Here are some tips on how you might be able to stretch your existing hardware rather than buying a new machine.

    What Can You Do?

    If you sized your current machine correctly, you may have more than enough excess capacity to stay with the existing hardware for a few more years.

    …

    Read more

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