001 Welcome to Season 2 of The incredible i Show! We are kicking off our new season with Jesse Gorzinski – the force behind Open Source! We sat down with Jesse between virtual conferences to get the latest on Apache Camel, IOT, RPM’s, Machine Learning and more. You don’t want to miss this show! Jesse Gorzinski, Senior Business Architect – Open Source Software on IBM i at IBMEmail: jgorzins@us.ibm.com Check out the new OSS landing page: http://ibm.biz/ibmioss https://twitter.com/IBMJesseGhttps://www.linkedin.com/in/ibmjesseg New this season One incredible Th(i)ng! Products, gadgets, recipes, music or things we are loving right now. (we’re still working on the title) Tony’s picks for this week (he has 2 things this week lol!):Microsoft Garage Mouse without Borders: Download Microsoft Garage Mouse without Borders from Official Microsoft Download CenterLogitech G613 Wireless Mechanical Gaming Keyboard: Logitech G613 Wireless Mechanical Gaming KeyboardPeg’s pick for the week: Peloton Bike: Peloton® | Indoor Exercise Bike with Online Streaming Classes. (onepeloton.com)This episode is sponsored by…COMMONhttps://www.common.org/homeMidrange Dynamics Change Management Software – Built for IBM i modernization!https://www.midrangedynamics.com/ Interested in sharing your IBM i story? Want to sponsor the podcast? We want to hear from you! Reach out to Peg at Peggy@theincredibleishow.com
Forrester Consulting Weighs Costs, Benefits of IBM i – IT Jungle
Taking A Centralized Approach To IBM i Security – IT Jungle
Get Virtually Packed For Common Europe Power Summer Camp – IT Jungle
FormaServe – How to get the BBC News Feeds in a RPG program on the IBM i.
In this short How To …. On IBM i Video set, we will be taking a look at how to show the BBC news feeds in a RPG program using embedded SQL.
We will be using the DB2 for IBM i HTTP Services to get the news feeds and then format them so our RPG program can display them/
Check out our Git Hub repository for all the source code, RPG, SQL and the display file, and lots more. It can be found at https://github.com/AndyYouens/f_Learning
— Contents —
00:00 – Intro
00:38 – What we trying to do?
01:08 – Configure Hot Spots in a 5250 session
01:22 – Your IBM i needs to talk to the BBC
01:53 – What are news feeds (RSS)
03:30 – DB2 HTTP Services
04:26 – SYSTOOLS Pr-req’s
05:18 – ACS Schemas
06:14 – Using HTTPGETBLOB
06:48 – Getting the XML from the News Feed
07:33 – Using SQL XMLTABLE & XMLPARSE functions
08:21 – 5250 Display file for the feeds
08:51 – RPGLE Program to display the feeds
10:50 – Check out learning.formaserve.co.uk & Powerwire.eu
11:14 – Wrap Up!
