Defining a DELETE Statement 

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>