Scalar. Inserts one XML value into another XML value.
Sybase CEP Engine locates the element nodes in value that match xpath. If Sybase CEP Engine locates any non-element nodes, it logs a warning and ignores the nodes. For each matched element tree, Sybase CEP Engine inserts the specified XML value as follows:
FIRST: Adds insert as the first child of the matched tree.
LAST: Adds insert as the last child of the matched tree.
AFTER: Adds insert after the matched tree (at the same level as the selected tree).
BEFORE: Adds insert before the matched tree (at the same level as the selected tree).
XMLDELETE
XMLUPDATE
The following example shows adding a tracking number to an order after the METHOD nodes:
INSERT INTO OutStream
SELECT XMLINSERT (O.orderVal,
XMLPARSE ('<TRACKINGNO>T060023456</TRACKINGNO>'),
AFTER '//METHOD')
FROM O;