Using XML with DB2

Audience

The course is designed for DBA’s, applications Programmers, users or other personnel who need to access the XML data.

Prerequisites

Those attending the course should be familiar with DB2.

Duration

2 days. Hands on.

Course Objectives

The course is designed to explain the features of XML with DB2, for z/OS or LUW. Accessing XML within a host language is also discussed. Practical exercises are all given to consolidate the theory sessions.

Course Content

Introduction
Traditional Methods for Managing XML Data
XML
Terms
Elements
Document
Namespace
Attributes
XDM
Well Formed XML
Object Definition
DB2 Extenders
Net Search Extender
Database Creation
Tablespace
Table
Views
MQT
Enabling a Database for Text Search
DB2TEXT
Creating a Full Text Index
Create Index Statement
Comparing XML Indexes With Relational Indexes
Index Terms
Text Index
Index Update
Index Synchronization
Index Data Types
Using XML Namespaces
XPath Expressions
Creating the Index Using Wizard
XML Compression
The DB2 Catalog
Using the Explain Statement
DB2 Commands
Zparms

SQL / XPATH
XPath
XQuery
Difference Between XPath/XQuery & SQL
Platform Similarities
Platform Differences
Querying XML
Plain SQL without any XPath
SQL/XML Path Embedded in SQL Statements
XQuery
XQuery with Embedded SQL
Notes
Plain SQL
Plain SQL SPUFI
XPath Text Search and Retrieval of XML Data
DB2 SQL/XML Functions
XML Publishing Functions
XMLPARSE
XMLDOCUMENT
XMLSERIALIZE
XMLNAMESPACES
XMLATTRIBUTES
XMLFOREST
XMLAGG
XMLPI
XMLTEXT
XMLEXISTS
XMLTABLE
Declaring a Default Namespace
Constant and Parameter Marker
Programming Language
Enterprise COBOL for z/OS
Generating XML from COBOL GENERATE
Error Handling
Exception Codes
ON EXCEPTION/COUNT
Hyphens
Upper-Case Element Names
Cobol Attributes that suppress XML Generation
XML Parse
Special Registers
DCLGEN
Fetch with Continue
Explain

UTILITIES
CHECK DATA
CHECK INDEX
COPY
LISTDEF
LOAD
REBUILD INDEX
RECOVER INDEX/TABLESPACE
REORG INDEX/TABLESPACE
REPAIR
REPORT
RUNSTATS
UNLOAD
DSN1COPY
BEST PRACTICES
Executing XQuery
Difference Between XPath/XQuery and SQL
Transforming the Result Set
FLWOR
Introduction
FOR/RETURN
LET
WHERE
ORDER BY
Command Line Processing Commands
Functions
Db2-fn:xmlcolumn
Filtering on the XML Element Values
Converting XML to HTML
Conditional Logic
Hybrid Queries
db2-fn:sqlquery
Embedding XQueries in SQL