The DELETE FROM statement deletes rows from a table in an external database based on a search condition.
A correlation name is created that you can use inside the search condition to refer to the values of columns in the table. This correlation name is either the name of the table (without the data source qualifier) or the explicit qualifier specified.
DELETE FROM Database.SHAREHOLDINGS AS H WHERE H.ACCOUNTNO = Body.AccountNumber;
This removes all rows from the SHAREHOLDINGS table where the ACCOUNTNO field in the table is equal to the AccountNumber in the message.
For information about handling database errors, see Capturing database state.
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ak04990_ |