• 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 … “Guru: DB2 For i XML Composition And The IFS”

  Read more

• Rest4i Eyes Digital Transformation Via API

  March 21, 2018 Alex Woodie

  A new company headed by IBM i software veterans is beginning to turn some heads with a new product aimed at helping IBM i shops with digital transformation strategies. Rest4i, as the outfit is called, says its LXR framework turns IBM i into a lean, mean REST API-serving machine.

  Stuart Milligan, who headed the UK software firm Databorough before it was sold to Fresche Legacy (now Fresche Solutions) way back in 2013, says LXR (pronounced “Lexer”) is the result of four years of investment and development in a “pure IBM i REST API solution.”

  Milligan describes LXR as … “Rest4i Eyes Digital Transformation Via API”

  Read more

• New IBM i Technology Refreshes Announced; Available Mid-March

  February 14, 2018 Dan Burger

  IBM yesterday announced that Technology Refresh 8 (TR8) for IBM i 7.2 and TR4 for IBM i 7.3 will provide support for Power9 hardware, enhancements for RPG, security enhancements, and a variety of new capabilities for licensed products. The support for Power9 will be covered elsewhere in this issue of The Four Hundred. Here, we’ll provide an overview of the IBM i operating system, licensed programs, and software.

  When TR enhancements include RPG, I like to begin there. Application developers using Rational Development Studio should take note of the new operation code referred to as DATA-INTO, which adds the … “New IBM i Technology Refreshes Announced; Available Mid-March”

  Read more

• Guru: Consuming A REST Web Service Using SQL And GET

  September 18, 2017 Mike Larsen

  The use of web services in the industry continues to grow, and sometimes it can be challenging to find information on how to work with them on IBM i. So, what is a web service? In a nutshell, web services allow systems to communicate via the web using file formats such as JSON and XML.

  This article demonstrates how to consume a REST web service using SQL. The example I’m working with uses the ‘GET’ verb to retrieve information from an Amazon Web Service (AWS). I created a simple REST Amazon Web Service that retrieves information about a pet from … “Guru: Consuming A REST Web Service Using SQL And GET”

  Read more

• Does IBM i Need More Databases?

  August 14, 2017 Alex Woodie

  There are many things that differentiate IBM i from other platforms, including its storage, security, and programming models. But one of the most unique aspects of the IBM i platform is its integrated DB2 database, which is used exclusively by practically all IBM i customers. You just don’t find this on other platforms. But perhaps it’s time for IBM i to diversify its database support?

  In many respects, DB2 for i is the platform’s greatest strength. IBM i is renowned for its transaction processing prowess that drives ERP and other line of business applications, and DB2 for i (formerly DB2/400, … “Does IBM i Need More Databases?”

  Read more

• IBM i, Watson & Bluemix: The REST Of The Story

  June 21, 2017 Dan Burger

  Integrated Web Services is nothing new for IBM i. But that doesn’t mean there’s nothing new in Web services. A couple of years ago, IBM introduced Bluemix, an integration framework that, among other things, allows applications on other systems to connect with business logic running on i. The Bluemix tooling was designed to consume REST APIs, which can be used to connect Watson and IBM i. That’s where the newness is evident.

  The plumbing that’s necessary to make these things happen is being built by the IBM i development team led by Tim Rowe, business architect for IBM i … “IBM i, Watson & Bluemix: The REST Of The Story”

  Read more

• Guru: The XML Composition Conundrum of XMLNAMESPACES or XMLATTRIBUTES

  April 3, 2017 Michael Sansoterra

  Hey, Mike:

  After reading the IT Jungle Guru tips on DB2 XML Composition (see Related Stories below), I’ve been able to build XML from relational data. I have everything working but now I need to enclose all data in a “Document” tag after the XML declaration like the example here:

  <?xml version="1.0" encoding="utf-8"?>
  <Document xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
  xmlns="http://MyCompany.com" 
  xsi:schemaLocation="http://MyCompany.com validate.xsd">
  

  I tried using XMLNAMESPACES but can’t get it to produce the “xsi:schemaLocation” tag. How can I construct the document tag I need?

  –N.C.

   

  The problem here is that the xsi:schemaLocation in your example is not a namespace, but … “Guru: The XML Composition Conundrum of XMLNAMESPACES or XMLATTRIBUTES”

  Read more

Next Articles