G532 DB2 and XML - Topical Outline

DB2 and XML - Topical Outline

Introduction

XML overview

XML and DB2

XML catalog tables

SYSIBM.SYSXMLRELS

SYSIBM.SYSXMLSTRINGS

Sample tables

Computer Exercise: Course Setup

XML functions in DB2 that build XML documents

XMLELEMENT

XMLATTRIBUTES

XMLCONCAT

XMLFOREST

XMLNAMESPACES

XMLAGG

XMLCOMMENT

XMLDOCUMENT

XMLPI

XMLTEXT

XMLPARSE

Computer Exercise: XML SQL functions, 1

XML functions in DB2 that access XML documents

XML2CLOB

XMLSERIALIZE

XPath, part 1

XMLQUERY

XMLEXISTS

XMLTABLE

XMLCAST

Computer Exercise: XML SQL functions, 2

XML in application programs

DCLGEN

XML variables

XML file reference variables

XML data modification

XML data retrieval

Single row SELECTs

Using cursors

XMLMODIFY function and partial updating

Computer Exercise: XML in Application Programs

XPath functions

XML indexes

XML index for XML joins

XPath index enhancements

XMLTABLE query transformation

Computer Exercise: XML Indexes

XML and utilities

CHECK DATA, CHECK INDEX, COPY, COPYTOCOPY, EXEC SQL,

LISTDEF, LOAD, QUIESCE, REBUILD INDEX, RECOVER, REORG,

REPAIR, REPORT, RUNSTATS, UNLOAD

UNLOAD and XML data

File reference variables with LOAD and UNLOAD

The DSNTIAUL program

Computer Exercise: Working with XML data with utilities

XML schemas

The Schema repository:

SYSIBM.XSROBJECTS

SYSIBM.XSROBJECTCOMPONENTS

SYSIBM.XSROBJECTHIERARCHIES

Schema validation

Type modifiers

DSN_XMLVALIDATE function

XMLXSROBJECTID function

Type modifier catalog tables

SYSIBM.SYSXMLTYPMOD,

SYSIBM.SYSXMLTYPSCHEMA

Schema stored procedures:

XSR_REGISTER

XSR_ADDSCHEMADOC

XSR_COMPLETE

XSR_REMOVE

Computer Exercise: Working with Schemas

Odds and ends

Document versioning

XML date and time data types

XML Data Type in SQL Procedures

DEFINE NO for LOB and XML table spaces

Binary XML

G532 / 3 Days

Materials version: V1.x

Course Objectives
Course Description
Home page