DB25 - DB2 XML Workshop
Duration1 Day (customisation)
Availability

Course Description

This course is aimed at DBAs and Programmers who need to understand how use DB2 to store and manipulate XML data.

During the course the delegate will learn how to define XML columns, create XML indexes, LOAD / parse XML documents and manipulate XML data both from within a program and using XQUERY / XPATH expressions.

Pre-requisites

A strong knowledge of using DB2 is required to attend this course. Athough the first section of this course contains an overview of XML, prior XML knowledge is advantageous. This can be gained by attending course EC50 - XML Introduction.

Objectives

The aim of this course is to provide the programmer, already familiar with DB2 applications program development, with the necessary skills required define, load and manipulate XML data.

On completion of this course the student will be able to:

  • define XML columns
  • define XML indexes
  • understand implicit XML object creation
  • access and manipulate XML from a program
  • use XML functions
  • manipulate XML from within a program
  • use File Reference Variables
  • use XQUERY / XPATH expressions
  • run LOAD, REORG and COPY with XML data

Environment

Development will be performed using:

  • IBM Mainframe
  • DB2 for z/OS or DB2 LUW - Versions 9, 10 or 11
  • COBOL, PL1 or Java if applicable

Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.

Course Details

OVERVIEW OF XML
XML Document Structure
Tags & Elements
Attributes
Well Formed Documents
Valid XML Documents
Viewing an XML Document
Using CSS Style Sheets
Using XSL Transformations
XML SYNTAX
XML Documents
XML Declaration
Elements
Element Hierarchy
Empty Elements
XML Names
Entity References
CDATA Sections
NAMESPACES
Namespace Definition
Uniform Resource Identifier
Namespace Syntax
Binding Prefixes to Namespace URIs
Default Namespaces
Non-Default Namespaces
XML GRAMMARS
XML Validation
XML Parsers & Validators
Document Type Definitions
XML Schemas
DOCUMENT TYPE DEFINITION (DTD)
DTD
Definition
Declaration
Formats
DTD Declaration
Internal Declarations
External Private Declarations
External Public Declarations
DTD Content
!ELEMENT Declaration
Content Model
!ATTLIST Declaration
Attribute Type
Processing Instructions
XML SCHEMAS
Schema Status
Schema Elements & Attributes
Simple Types
Complex Types
Elements
Attributes
ComplexType
Compositors
Sequence
Choice
All
Attributes
Empty Elements
Attaching an XML schema to an Instance Document
XML Schema
Schema Structures
Using References
Using Groups
User-defined Simple Types
User-defined Complex Types
Content Type Libraries
DB2 XML SUPPORT / PUREXML
XML Terminology
XML Data Model
Well Formed Documents
Valid Documents
Overview of pureXML
XML Data Type
Implicit XML Objects Created
XML Tablespace
XML Node Index
XML DOCID Index
Adding XML Columns to a Table
Node Storage
Relational Data vs XML (Hierarchical) Data
Displaying XML Information
The DB2 XML Parser
Schema Validation - The XML Schema Repository (XSR)
XML Decomposition
XML Indexes
Index Considerations
Application development
Utilities
DB2 XML FUNCTIONS
Accessing XML Data
XML2CXML Function
Scalar Functions
XMLSerialize Function
XMLElement Function
XMLAttributes Function
XMLForest Function
XMLConcat Function
XMLAgg Function
XMLNamespaces Function
XMLComment Function
XMLDocument Function
XMLPi Function
XMLText Function
XMLParse Function
xPath
XPath Specification
Xpath Function - XMLQuery
Xpath Function - XMLExists
Xpath Function - XMLCast
Xpath Function - XMLTable
XPath Axes
DB2 PROGRAMMING WITH XML DATA
XML Data Manipulation
Inserting Or Updating XML Values
Declaring XML Host Variables
Example Using XML Variables
XML Manipulation
Using XML Locators
Declaring XML Locator Host Variables
Holding Locators
Freeing Locators
Example Using XML Locators
XML Limitations
XML Locator Considerations
XML Locators and XML Integrity
File Reference Variables
Defining File Reference Variables
File Reference Variables - Example
Loading Data using File Reference Variables
File Reference Variables - New DSNZPARM
Fetch Continue
Fetch Continue Example
Fetch Continue Considerations
Locking XML Data
XML Locking Summary
XML Tablespace Logging
XML Bufferpool Management
DB2 UTILITY SUPPORT FOR XML
Load Utility - XML Data
Loading Rowids
Reorg Utility - XML Data
Copy Utility - XML Data
Recovering XML Data to a Point-In-Time
XML Recovery States
Procedure For Recovering Invalid XMLs
Recover Utility - XML Data

Course Format

The course contains many practical exercises to ensure familiarity with the product. On completion of this course students will be able to develop application programs which use advanced programming techniques.

The comprehensive Student Guide supplied is fully indexed serving as a useful reference tool long after the course has finished. Delegates will also be able to access a free help-line with technical questions relating to topics covered on the course.