XMLDELETE()

Syntax

XMLDELETE( value, xpath )

Usage

Sybase CEP Engine uses XPATH to locate the element trees specified by xpath in value. Sybase CEP Engine logs a warning for any non-element nodes it finds in value, but otherwise ignores them. It deletes each element tree it finds matching xpath, in document order. If both a tree and an ancestor of the tree match, Sybase CEP Engine only deletes the ancestor.

See Also

• XMLUPDATE

• XMLINSERT

Example

The following example shows removing the shipping METHOD nodes from the value in the orderVal column:

INSERT INTO OutStream
SELECT XMLDELETE (O.orderVal, '//METHOD')
FROM O;