Generating and Consuming XML

This course is designed for programmers that need to generate and consume XML with SQL

It is assumed that participants have at least a basic knowledge of SQL. Participants should also be familiar with ACS-Run SQL Scripts.

Generating XML Documents

• XML Basics
• Data Type: XML
• SQL XML Publishing Functions
  • Scalar Functions for generating (nested) Elements
    • With/Without XML Attributes
    • With/Without Namespaces
  • Aggregate Functions for accumulating XML-Elements over multiple Rows
• Generating (more) complex XML-Documents
• Generating XML-Documents with embedded SQL

Consuming XML Documents

• Annotated Schema Decomposition
• XMLTABLE Table Function
  • XPath Syntax
  • Accessing XML Columns
  • Accessing IFS Files
  • Accessing Web-Services
• Generating (more) complex XML-Documents
• Generating XML-Documents with embedded SQL

Reading and Writing XML-Data into the IFS

Consuming XML-Data returned by Web-Services