Welcome to the Online Session Guide for the COMMON 2016 Annual Meeting and Exposition. Using this tool, you can access information regarding the sessions offered, build a custom schedule, print off handouts, and participate in session evaluations. We look forward to seeing you in New Orleans!
View analytic
Tuesday, May 17 • 2:00pm - 3:15pm
35CP Shred XML to DB2 Tables without Using Sharp Objects

Sign up or log in to save this to your schedule and see who's attending!

Shredding isn't just for cabbage anymore. IBM i 7.1 brought us a new capability to decompose (shred) XML streams and files directly into DB2 tables. XML is becoming the defacto method for transmitting data between systems and with this facility, no longer is it necessary to write a program to populate your application tables from an incoming XML dataset. A recent development project sought to replace a system that used flat text files and traditional COBOL programs to load database tables with XML decomposition. The project was successful. This session will walk through the process of creating the annotated XML Schema file that defines the data mapping process, registering that schema into the database,and ulitmately shredding some XML into the target tables.

Learning Objectives:

  • Create an annotated XSD to support decomposition

  • Register an annotated XSD into the database

  • Decompose an XML stream into one or more DB2 table

This is session 600219

avatar for Randy Dufault

Randy Dufault

Genus Technologies LLC

Tuesday May 17, 2016 2:00pm - 3:15pm
Jasperwood | Third Floor
  • Session Content Level Intermediate
  • Operating System IBMi, Linux
  • Audience: Developers supporting systems that exchange data with other systems.

Twitter Feed