Scribd
Upload
15 views11 pages

XML Language

The document provides an overview of XML, highlighting its features, advantages, and differences from HTML. It includes practical examples of loading XML data into databases using cursors and the LOAD utility. Additionally, it touches on XML parsing and references related to the topic.

Uploaded by

bhartivijaysoni291911
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
15 views11 pages

XML Language

The document provides an overview of XML, highlighting its features, advantages, and differences from HTML. It includes practical examples of loading XML data into databases using cursors and the LOAD utility. Additionally, it touches on XML parsing and references related to the topic.

Uploaded by

bhartivijaysoni291911
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

XML (Extensible Markup Language)

Features of XML
o
The difference between XML and HTML
o
Advantage of XML
XML Documents Must Have a Root Element
Simple XML Document
Application of XML
DECLARE cursor_income_level1 CURSOR FOR SELECT * FROM customers WHERE XMLEXISTS('$DOC/customer[income_level=1]'); LOAD FROM cursor_income_level1 OF CURSOR INSERT INTO level1_custom
LOAD FROM [Link] OF DEL XML FROM /home/user/xmlpath INSERT INTO USER.T1

Loading XML data

oThe load utility can be used for the efficient movement of large
volumes of XML data into tables.
LOAD FROM [Link] OF DEL XML FROM /home/user/xmlpath INSERT INTO USER.T1

o Loading XML data using a declared cursor is supported. The following example
declares a cursor and uses the cursor and the LOAD command to add data from
the table CUSTOMERS into the table LEVEL1_CUSTOMERS:
DECLARE cursor_income_level1 CURSOR FOR
SELECT * FROM customers
WHERE XMLEXISTS('$DOC/customer[income_level=1]’);
LOAD FROM cursor_income_level1 OF CURSOR INSERT INTO level1_customers;
XML Parsing
References

You might also like