XML Archives - IT Jungle

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
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 …
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 …
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 …
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, …
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 …
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 …
Read more

Content archive

Recent Posts

Subscribe

Pages

Search

Guru: DB2 For i XML Composition And The IFS

Rest4i Eyes Digital Transformation Via API

New IBM i Technology Refreshes Announced; Available Mid-March

Guru: Consuming A REST Web Service Using SQL And GET

Does IBM i Need More Databases?

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

Guru: The XML Composition Conundrum of XMLNAMESPACES or XMLATTRIBUTES

Content archive

Recent Posts

Subscribe

Pages

Search