• 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

  • LANSA Developing Business Intelligence Tool
  • Blazing The Trail For VTL In The Cloud
  • Data De-Dupe Gives VTL Customers More Options
  • Four Hundred Monitor, March 29
  • The Big Spending On IT Security Is Only Going To Get Bigger
  • IBM Tweaks Some Power Systems Prices Down, Others Up
  • Disaster Recovery: From OS/400 V5R3 To IBM i 7.4 In 36 Hours
  • The Disconnect In Modernization Planning And Execution
  • Superior Support: One Of The Reasons You Pay The Power Systems Premium
  • IBM i PTF Guide, Volume 25, Number 13

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