Example: Using XMLPI to Create an XML Processing Instruction Node - 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 following query returns a sequence with a processing instruction whose serialization is 
<? orderpi 'NextDayShipment'?>

SELECT XMLPI(NAME orderpi, 'NextDayShipment');

Query result:

XMLPI( NAME orderpi , 'NextDayShipment' RETURNING SEQUENCE )
------------------------------------------------------------
<?orderpi NextDayShipment?>