Target Audience
This course is aimed at Programmers who need to understand how to define and manipulate XML data within a DB2 environment.
Pre-requisites
A strong knowledge and experience in DB2 Applications Development is required to attend this course. The first section of this course introduces the delegate to XML. Prior XML knowledge is therefore advantageous but not essential.
Course 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
-
understand implicit XML object creation
-
access and manipulate XML from a program
-
use XML functions
-
use File Reference Variables
-
use XPATH expressions
-
run LOAD, REORG and COPY with XML data
Course Environment
Development will be performed using:
-
IBM Mainframe
-
COBOL, PL1 or Java
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.
|