• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Missing In Action: The Full Outer Join

    April 11, 2007 Hey, Ted

    As far as I know, you haven’t covered my situation in Four Hundred Guru. I need to join two physical files using SQL. It’s possible that some records in the first file won’t have matches in the second file. It’s also possible that some records in the second file won’t have matches in the first file. What type of join do I use?

    –Chris

    You need a full outer join, Chris, and DB2/400 (or whatever they call it these days) won’t handle it–yet. I expect IBM to add the full outer join any release now.

    To simulate the full

    …

    Read more
  • Reader Feedback on One-Man System i Shops

    April 11, 2007 Hey, Bruce

    I read your recent article about using OpsNav to monitor jobs. What caught my eye was your lead line about being a one man shop. I didn’t think there were too many of us left! Anyway I just wanted to bounce some ideas off someone.

    The first being, how do I decide what kind of RPG modernization product I should be looking at. LANSA, Profound Logic, BCD, CGIDEV2–there are so many out there, what do I choose? (Well, there is also WebSphere, but I have not heard great things about it.) Or should I be looking at

    …

    Read more
  • Admin Alert: The Process and Pitfalls of Duplicating Libraries

    April 11, 2007 Joe Hertvik

    Last fall, I wrote a column discussing the pitfalls of duplicating files to a test library. However copying files and logicals between environments is just the tip of the iceberg. There is an entirely different set of issues involved when you are trying to duplicate an entire library for test purposes. To that end, here’s my procedural checklist for making an (almost) exact copy of any native i5/OS library.

    Why We Copy

    There are many reasons for copying i5/OS libraries, but the most common needs are to create or refresh a test environment with production data, to use an

    …

    Read more

Content archive

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

Recent Posts

  • 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
  • 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

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