• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Guru: Generating XML Using SQL – The Easy Way

    September 18, 2023 Bob Cozzi

    There are many verbose methods of generating XML. You can:

    • Write your own RPG code
    • Using a free or third-party API
    • Use SQL iQuery OUTPUT(*XML) option
    • Use the built-in SQL XML functions such as XMLELEMENT

    I’m sure there are others, but these seem to be the most popular.

    For years I had been using the XMLELEMENT approach; a rather verbose set of XML function built into Db2 for i SQL. In fact, SQL iQuery’s OUTPUT(*XML) is based on that feature. It simply regenerates your SQL statement using XMLELEMENT statements for each output column/field name.

    But if you’re using something IBM …

    Read more

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Rocket DevOps Now Supports VS Code
  • DR Testing As A Service: One More Thing That You Don’t Have To Do
  • The First Step In DevOps Is Not Tools, But Culture Change
  • As I See It: IT Come Home
  • IBM i PTF Guide, Volume 25, Number 39
  • ARCAD’s Deal with IBM for DevOps In Merlin Is Exclusive
  • In The IBM i Trenches With: Maxava
  • Is The Cloud On Your IBM i Horizon?
  • Four Hundred Monitor, September 20
  • IBM i PTF Guide, Volume 25, Number 38

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2023 IT Jungle