• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Development Environments

    May 12, 2010 Paul Tuohy

    It happens at every conference I speak at. Over a cup of coffee (or other liquid refreshment) someone will ask me about my development environment.

    • How many libraries do you use?
    • Where do you keep source–especially for service programs?
    • How do you manage binder language?

    So, if for no other reason than allowing me to answer with: “you can read about it at IT Jungle,” here is a description of my current development environment for a little System i Developer application I’m working on.

    But First

    Of course, your development environment may well be dictated by a change management system.

    …

    Read more
  • Two Ways to Prevent Division by Zero in SQL

    May 12, 2010 Ted Holt

    Everybody above the age of 8 knows that division by zero is a no-no, or at least they should. Everybody who’s used SQL for any amount of time knows that we can use a CASE expression to prevent division by zero. But do you know the other way to prevent division by zero in SQL?

    Assume a database file called SomeTable, with fields called Quantity and Amount. Let’s divide Amount by Quantity. First, here’s the usual case statement.

    select itnbr, Amount, Quantity,
           case when Quantity <> 0
                   then Amount / Quantity
                else 0 end
      from SomeTable
    

    If Quantity is not

    …

    Read more
  • Admin Alert: Diary of a Production System Upgrade, Part 2

    May 12, 2010 Joe Hertvik

    Last issue, I began discussing a Power i/Power 6 upgrade that was recently completed in my shop. This review served as a case study for discussing some techniques and pitfalls in bringing up new hardware. I’m offering this examination to document some lessons I learned while upgrading in order to help other i/OS administrators who are installing new hardware. This week, let’s continue the story.

    I previously documented how we started swapping out an existing production System i/Power 5 machine for an upgraded model 8204 IBM i Power 6 box with 96 Gb of memory and 4 processors. Over

    …

    Read more

Content archive

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

Recent Posts

  • With Power11, Power Systems “Go To Eleven”
  • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
  • Izzi Buys CNX, Eyes Valence Port To System Z
  • IBM i Shops “Attacking” Security Concerns, Study Shows
  • IBM i PTF Guide, Volume 27, Number 26
  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25

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