• 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

• Google Close to Launching IBM i Cloud Service, Will Says

  June 4, 2018 Alex Woodie

  One of the laments of Power chip types everywhere is the lack of a public cloud service for Power applications. While Linux and Windows folks can run their X86 workloads on multiple public clouds, the opportunities for hosting IBM i, AIX, or Power Linux workloads are limited to so-called private clouds. But according to IBM i chief architect Steve Will, that could soon be changing.

  While neither IBM nor Google have made any official announcements about Google running IBM i in its public cloud, Will talked openly about the relationship between the two tech giants at COMMON‘s PowerUp conference …

  Read more

• UCG Becomes The Guardian Of Contract Management

  June 4, 2018 Timothy Prickett Morgan

  The small and medium business market for systems has always been larger than the AS/400 and its progeny, and even if the AS/400 loomed larger in decades past, it has been a long time since people in the IBM i market thought that everything can and should be done on the platform. Some applications work just fine running alongside the AS/400 and its integrated database, and other applications are freestanding and complementary.

  Jim Kandrac, the founder and president of UCG Technologies, the IBM i system reseller located outside of Cleveland, Ohio, that is best known for its VAULT400 cloud …

  Read more

• Guru: Ready or Not! Part 3 Of Big Changes In RDi V9.6, Compare/Merge, Code Coverage, and More

  June 4, 2018 Susan Gantner

  This is the third in my series of tips on RDi V9.6. In this one I’ll cover the new compare and merge support, along with improvements to code coverage and a few other smaller enhancements in V9.6. I originally thought this would be the last in the series, but IBM recently made available a new point release that introduced enough new features to mean I’ll be adding at least one more tip.

  Compare And Merge

  The ability to compare the content of two source members is not new to RDi, but with V9.6 the facility now offers the option to …

  Read more

• Fresche Takes $60 Million To Fuel Growth, Consolidate Market

  June 4, 2018 Alex Woodie

  Fresche Solutions is making big moves, and readying itself to make even bigger ones. With $60 million in the bank – and a line of eager equity firms willing to invest millions more – the IBM i software and services firm is poised to significantly expand operations in a bid to capture what executives foresee as a loosening of budgets and uptick in demand around application modernization.

  Fresche Solutions had just announced the $60 million financing round at the COMMON PowerUp conference two weeks ago, and its CFO was itching to get out on the expo floor. That’s where the …

  Read more

• Happy Days Are Here Again For Systems

  June 4, 2018 Timothy Prickett Morgan

  A combination of increases in memory and CPU prices, beefier configurations often with GPU or FPGA accelerators, and outright ebullient demand for compute capacity is making the server business look like it is exploding when it is merely expanding at a more-than-healthy clip.

  In the first quarter, according to the box counters at IDC, server revenues were up an astounding 38.6 percent to $18.82 billion, the kind of number we have never seen in the history of the server racket. Server shipments – and it is getting hard to count the nodes sometimes – rose by 20.7 percent to just …

  Read more

• IBM i Finds A Youthful Swagger Down In Texas

  May 23, 2018 Alex Woodie

  The IBM i platform and ecosystem may not be what they once were. Thirty years of relentless OLTP processing will do that to you. But if COMMON’s POWERUp 18 conference this week in San Antonio is any indication, the box itself and the ecosystem it supports are far from dead.

  Signs of life in IBM i-land were evident everywhere at the Marriott Rivercenter, the hotel where about 1,000 IBM i professionals, vendors, and IBMers spent the past four days holed up for COMMON‘s annual conference, which was renamed POWERUp.

  Here are some of the highlights of the show, which …

  Read more

• Syncsort Talks Rebranding, IBM i Product Strategy

  May 23, 2018 Alex Woodie

  Think you know Syncsort? Who the company is and what it does? Well, you might want to take a fresh peek, because the company that acquired Vision Solutions and a handful of other IBM i software firms is on the move. In fact, it used the COMMON POWERUp 18 conference in San Antonio this week to begin rolling out a long-awaited company rebranding and major product refresh – including its new Fusion unification strategy and several new IBM i products.

  First of all, the company will continue to be known as Syncsort. The executives leading the Pearl River, New …

  Read more

Previous Articles Next Articles