Canonical XML Publishing - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

The canonical XML representation of SQL query results takes the form of a document element named QuerySchema which has 0 or more child elements named Row. Each Row element corresponds to a row in the SQL query result set. The Row elements have children elements corresponding to the projection list of the SQL query. For example, consider an SQL query such as the following:

SELECT CUSTDTL.ID AS CustomerID, CUSTDTL.NAME, CUSTDTL.ADDRESS, CUSTDTL.PHONE1,
   CUSTDTL.PHONE2, CUSTDTL.FAX, CUSTDTL.EMAIL, ORDERDTL.ORDER_ID AS OrderNumber,
   ORDERDTL.ORDER_DATE AS OrderDate, ORDERDTL.CONTACT AS OrderContact,    ORDERDTL.CONTACT_PHONE AS OrderPhone, ORDERDTL.SHIP_TO_ADDRESS AS OrderShipTo,
   ORDERDTL.SUB_TOTAL AS OrderSubTotal, ORDERDTL.TAX AS OrderTax, ORDERDTL.TOTAL AS
   OrderTotal, LINEITEMDTL.ITEM_ID AS ItemID, LINEITEMDTL.QUANTITY AS ItemQuantity,
   LINEITEMDTL.PART_NUMBER AS ItemPartNumber, LINEITEMDTL.DESCRIPTION AS ItemDescription,
   LINEITEMDTL.UNIT_PRICE AS ItemUnitPrice, LINEITEMDTL.PRICE AS ItemPrice
FROM CUSTDTL, ORDERDTL, LINEITEMDTL
WHERE CUSTDTL.ID=ORDERDTL.CUSTOMER_ID AND ORDERDTL.ORDER_ID=LINEITEMDTL.ORDER_ID;

The CUSTDTL, ORDERDTL, and LINEITEMDTL tables reflect the purchase order history data.