Let us help you find the training program you are looking for.

If you can't find what you are looking for, contact us, we'll help you find it. We have over 800 training programs to choose from.

banner-img

Course Skill Level:

Foundational

Course Duration:

2 day/s

  • Course Delivery Format:

    Live, instructor-led.

  • Course Category:

    Database

  • Course Code:

    DB2COXN22J02

Who should attend & recommended skills:

New XML in a z/OS environment with basic computer concepts and relational data management systems experience

Who should attend & recommended skills

  • This course is primarily directed toward new users of XML in a z/OS environment
  • Computer concepts: Basic (1-2 years’ experience)
  • Relational data management systems: Basic (1-2 years’ experience)

About this course

This instructor led class introduces using XML in z/OS, how XML is used in COBOL programs, and DB2 XML concepts.
Workshops: z/OS platform will be used to run class problems coded by the students.

Skills acquired & topics covered

  • After successful completion of this course, the student will be able to:
  • Describe XML system concepts
  • Describe the basic structures in XML
  • Write basic XML statements using COBOL

Course breakdown / modules

  • Mainframes systems overview
  • XML – Business Value
  • Overview of XML on System z
  • Basic XML standards
  • XML Basics
  • Structures and Concepts
  • XML Documents
  • z/OS XML System Services
  • Namespaces
  • Encoding
  • Identify XML namespaces in a document
  • Classify XML namespaces into categories
  • DTD – Document Type Definition
  • Identify components of a DTD
  • Define components and constructs in XML
  • XML schema definition
  • General scheme for invoking z/OS XML System Services for parsing
  • Workshop – Lab Exercises

  • Enterprise COBOL for z/OS
  • Common methods of acquiring the document
  • COBOL andXML basics
  • XML parsing overview
  • XML PARSE
  • XML GENERATE error handling
  • XML host variables in COBOL
  • Creating an XML Document
  • Registers to Receive and Pass data
  • Handling errors generating output
  • Workshop – Lab Exercises

  • Storing XML data in DB2 Tables
  • Indexing XML data
  • XML Generation Functions in DB2
  • XMLDOCUMENT
  • XMLELEMENT
  • XMLEXISTS
  • XML and UPDATE, DELETE, INSERT
  • Getting specific data out of a XML column with a SQL statement
  • XMLNAMESPACE
  • XMLQUERY
  • XMLSERIALIZE
  • XMLTABLE
  • Workshop – Lab Exercises
  • Class review