
Using XQUERY in DB2 - 11 Questions
- or -
Post a project like this4364
£20(approx. $26)
- Posted:
- Proposals: 1
- Remote
- #227051
- Awarded
Description
Experience Level: Entry
I have 11 questions regarding DB2 and XQUERY. The questions are
The questions are part of a PDF exercise booklet which will be provided to you. The 19 page PDF explains and gives of examples of similar problems, and then asks questions based on those examples.
Here are 2 examples of the questions:
Explain what the following command does:
xquery db2-fn:sqlquery ("select porder from DANDY.purchaseorder where STATUS='Unshipped' ");
..AND..
Modify the following query to return the customer’s name instead of their CID attribute The name
is an XML element in the INFO column of the CUSTOMER table. Instead of the name between
.. tags, your result output should provide the name between .. tags.
select xmlserialize(
content xmlelement(
name "tr",
c.cid
)
as clob(144)
) as "result"
from DANDY.customer c
..All the questions are of this nature. If you'd like full details please express your interest and I'll pass on the full PDF for you to review.
Please provide the answers this week
Thank you.
The questions are part of a PDF exercise booklet which will be provided to you. The 19 page PDF explains and gives of examples of similar problems, and then asks questions based on those examples.
Here are 2 examples of the questions:
Explain what the following command does:
xquery db2-fn:sqlquery ("select porder from DANDY.purchaseorder where STATUS='Unshipped' ");
..AND..
Modify the following query to return the customer’s name instead of their CID attribute The name
is an XML element in the INFO column of the CUSTOMER table. Instead of the name between
.. tags, your result output should provide the name between .. tags.
select xmlserialize(
content xmlelement(
name "tr",
c.cid
)
as clob(144)
) as "result"
from DANDY.customer c
..All the questions are of this nature. If you'd like full details please express your interest and I'll pass on the full PDF for you to review.
Please provide the answers this week
Thank you.

Daniel D.
100% (47)Projects Completed
43
Freelancers worked with
42
Projects awarded
47%
Last project
18 Jul 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies