Example: Using XMLPI to Create an XML Processing Instruction Node

Teradata Vantage™ XML Data Type

brand
Software
Teradata Vantage
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?>