Using XML with DB2

Code: DB2XML

Description

The course is designed to explain the features of XML with DB2, for z/OS or LUW.

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.

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.

Topics

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.
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.

Price (ex. VAT)

€ 1.640,00 per person

Duration

2 days

Schedule

Delivery methods

  • Classroom
  • On-site (at your location)
  • Virtual (instructor online)

Questions?

Write us and we will contact you to discuss your requirements
contact us