TFH Volume: 28 Issue: 40 Archives

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

Guru: DB2 For i XML Composition And The IFS

As I See It: The Hunt For Perfect Storage

IBM i PTF Guide, Volume 20, Number 22

Content archive

Recent Posts

Subscribe

Pages

Search