• 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

Next Articles