• Guru: An Introduction to Processing XML With RPG, Part 3

  September 5, 2018 Jon Paris

  Author’s Note: In part 1 and part 2 of this XML series, I introduced you to the basics of using RPG’s XML support. In this tip we begin to explore some of the challenges that you may face when processing commercial XML documents, and the support XML-INTO offers to handle them. In particular we will be reviewing how to ignore parts of the document through the use of the path= %XML option. We will also review how to handle XML documents that make use of namespaces and how to handle XML element names that include characters that are not valid …

  Read more

• Guru: An Introduction to Processing XML With RPG, Part 2

  August 29, 2018 Jon Paris

  In the first part of this series for Guru Classic, I introduced you to the basics of using RPG’s XML-INTO op-code. In that tip I showed how the provision of a count provided by RPG in the PSDS can be used to determine how many of a repeating element were processed.

  However, as I noted at the time, this can only be used when handling a repeating outer element. But what if there is a repeating element within each of those outer elements? In this second part of the series we will be studying how to handle those situations. …

  Read more

• Guru: A Bevy of BIFs – %Dec to the Rescue

  August 1, 2018 Susan Gantner

  Author’s Note: This tip was first published back in 2009. I’ve updated the code examples here to use free format declarations. In addition I’ve added the potential use of %ScanRpl, which didn’t exist at the original publication date.

  More and more in RPG applications these days, it seems we need to process data that comes from “the dark side.” Translation: from a non-i system. This data could be coming from a browser screen via an RPG CGI program, from a CSV (comma-separated values) flat file, from an XML or JSON document, or myriad other ways. One thing these dark sources …

  Read more

• Guru: An Introduction to RPG’s XML-INTO, Part 1

  August 1, 2018 Jon Paris

  Author’s Note: The original version of this article was written in the V6 timeframe and included references to V5R4. References to the V5R4 limitations have been removed from this updated version. I have also updated the data definitions to take into account RPG’s ability for the direct coding of nested data structures rather than having to use LikeDS as before.

  RPG IV’s built-in XML support has been available for some time now, having been originally introduced with V5R4 back in 2006. However, it wasn’t until the advent of V6 with its removal of many of RPG’s size limits that it …

  Read more

• Guru: RPG’s New DATA-INTO

  June 18, 2018 Jon Paris

  In this tip I’m going to give a brief introduction to the latest addition to the RPG language. The new DATA-INTO op-code. DATA-INTO is IBM’s response to the oft-asked question: “When is IBM going to introduce JSON-INTO so we can process JSON as easily as XML?”

  DATA-INTO provides this capability, but IBM has very cleverly given it functionality that goes way beyond what a simple JSON-INTO op-code could ever have done. DATA-INTO is effectively a cross between XML-INTO and Open Access. Like XML-INTO it uses the names of items and their hierarchy to unpack the document into RPG variables. Like …

  Read more

• 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

Previous Articles