Back to Browse

Coding in RPG (IBM i/AS400). Using XML files with RPG and SQL.

2.9K views
Feb 4, 2024
13:06

In this sample video, I'd like to show you an example of how you can import XML files using SQL into a table that is in your IBMi, and later how you can parse it also using SQL, importing the information it has into a data structure, from a RPG program. I think it is a very useful video, for all people that still needs to use XML, and doesn't want to use data-into, xml-into or xml-sax. Please, let me know what you think about it. Leave your comments below. Don't forget to subscribe! (Update!): There's a second part of this video, that you can watch here: https://youtu.be/agpWdrCSJyY #ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #as400 #common #modernize #SQLtraining #ibmchampion 0:00 Introduction 0:30 Showing the XML file that I will use in the example 0:56 Creating a table that I will use later for importing the XML file 1:55 Starting creating the program using VS Code 2:30 Creating a template for using in the program 3:35 Importing the XML file into my table using SQL 5:26 Using SQL for parsing the XML document that is inside my table 10:10 Using a debug session to see how it works on the green screen 12:40 Final comments and ending

Download

0 formats

No download links available.

Coding in RPG (IBM i/AS400). Using XML files with RPG and SQL. | NatokHD