• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • End-Of-Year Feedback

    December 4, 2013 Hey, Esteemed IBM i Professional

    I hope 2013 was a good year for you. It was my best year in a while. I left a dysfunctional bureaucracy for a company where I can make a difference. I renewed several old acquaintances. And I found out from LinkedIn that I know someone who knows someone who knows Haynes Brooke, the guy who plays the sun in the Jimmy Dean sausage commercials. Let’s close out the year with some of the feedback you’ve been kind enough to send to me.


    Hey, Ted:

    In Alan’s Easy Method For Building A CSV File From A Report, you

    …

    Read more
  • Three Powerful SQL Words

    December 4, 2013 Ted Holt

     

    Louisa May Alcott said, “I like good strong words that mean something.” So do I, especially when they’re good strong SQL words. It gives me great pleasure today to share three powerful SQL words with you.

    Consider the following summary query:

    select d.ItemNumber,
           sum(d.Quantity) as Qty,
           sum(d.Quantity * d.Price) as Extended
      from InvoiceLines as d
     group by d.ItemNumber
     order by 1
    

    Here’s the result set:

    ITEMNUMBER      QTY      EXTENDED
      A-1             8         88.00
      A-3             7         35.00
      A-7             7         52.00
      B-1            26         51.25
      Z-3             2         18.00
    

    Standard stuff, yet very powerful. It beats writing an RPG program to read a file, check

    …

    Read more
  • Admin Alert: Four Ways To Move An IBM i Partition, Part 1

    December 4, 2013 Joe Hertvik

    I’m currently working with a client to migrate three IBM i partitions to new Power 7+ machines located in two data centers in different states. While there are several ways to approach migration, over the next two issues I’ll discuss four specific techniques for moving an IBM i partition to a new location and the different tasks you have to perform for each technique.

    Four Ways To Move An IBM i

    In general, there are four techniques for moving an IBM i partition to a different machine:

    1. Restore the partition in place or to a new location using the same
    …

    Read more

Content archive

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

Recent Posts

  • IBM i Has a Future ‘If Kept Up To Date,’ IDC Says
  • When You Need Us, We Are Ready To Do Grunt Work
  • Generative AI: Coming to an ERP Near You
  • Four Hundred Monitor, March 22
  • IBM i PTF Guide, Volume 25, Number 12
  • Unattended IBM i Operations Continue Upward Climb
  • VS Code Is The Full Stack IDE For IBM i
  • Domino Runs on IBM i 7.5, But HCL Still Working on Power10
  • Four Hundred Monitor, March 6
  • IBM i PTF Guide, Volume 25, Number 11

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 © 2023 IT Jungle