Using XQUERY in DB2 - 11 Questions

  • Posted:
  • Proposals: 1
  • Remote
  • #227051
  • Awarded
Shruthi S.
has already sent a proposal.
  • 0

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.

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.