Show TOC

Defining a DELETE StatementLocate this document in the navigation structure

Use

You use this statement to delete table values.

Format of DELETE Statement

<StatementName>

<dbTableName action="DELETE">

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName3>

Procedure
  1. Enter the condition under which the table values are to be deleted in one or more <key> elements.

    Column values within a <key> element are combined with a logical AND; different <key> elements are combined with a logical OR.

  2. If you do not enter a <key> element, or if you enter an empty <key> element, no condition is specified. The entire table is deleted. If you want to ensure this does not happen, select Key Tags Mandatory in the adapter configuration.

    If you have not formulated a condition in the <key> elements, but have selected Key Tags Mandatory, this results in an error in message processing with a corresponding error output.

Result

The corresponding SQL statement for the XML structure above is as follows:

"

DELETE FROM dbTableName  WHERE ((col2='val2old' AND col4='val4') OR (col2='val2old2'))

"

The response document contains one element:

<delete_count>count</delete_count>