• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Guru: DB2 For i XML Composition And The IFS

    June 11, 2018 Michael Sansoterra

    Hey, Mike! Regarding Composing An XML Document From Relational Data, Part 1, I have built an XML document using DB2 and i. When I run the query, I get a worthless result set. How do I use the SQL XML functions to get a usable XML file?

    This question comes from reader RA, and he doesn’t exaggerate. The result set from his XML-based query looks like this:

    ....+....1....+....2....+....3....+....4....+
    ************Beginning of data************** 
    
    XMLDATA 
    -------- 
    #CGULIB#
    
      1 RECORD(S) SELECTED.
    
     ************End of Data********************
    

    Notice that DB2 for i does nothing to make the XML attractive to human eyes as the entire XML …

    Read more
  • As I See It: The Hunt For Perfect Storage

    June 11, 2018 Victor Rozek

    I have a garage so full of stuff my car winters outdoors. For all I know, D.B. Cooper stashed his loot in there, which is why it has never been found. After a fruitless hour searching for a power washer attachment, I would have been happy to set the whole mess ablaze.

    If the first half of my life was about acquiring stuff, the second half is about trying to get rid of it. Without much success. Abundance, of course, is not the worst difficulty ever to befall humankind, but like too much of any good thing, indulging yourself is …

    Read more
  • IBM i PTF Guide, Volume 20, Number 22

    June 11, 2018 Doug Bidwell

    We are jumping around a bit this summer, so bear with us. We are running in both the Monday and the Wednesday editions of The Four Hundred this week to get caught up after a hiatus last week of the Wednesday issue. The news tends to be light in the summer, as you all know, so we often consolidate to one publication a week. This is particularly true after COMMON. Er, PowerUp 18.

    So here is what is going on. The Spectre/Meltdown (SM) PTFs have been rolled into the latest Security Group level for IBM i 7.3, 7.2, and …

    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