Delete

The Delete transform deletes one or more rows of data from a database table.

Use the Delete transform to delete one or more rows of data that match a configured Where clause from a database table. For more information, see Deleting data from a table.

The database table structure needed to create your Delete transform is specified in a database definition file (.dbm file) that you select from the Data Design project used to create the message map. The database definition can be discovered by connecting to a data server from the tooling.

When your message map has been deployed to an integration server, and your message map is run, the database server that is used by the IBM® App Connect Enterprise runtime component to process your Delete transform is specified by the JDBC Providers policy. The JDBC Providers policy name must have the same name as the database name that is specified in your Delete transform during development.