<?php
$dbh = new PDO('odbc:sample', 'db2inst1', 'ibmdb2');

$cnt = $dbh->exec("DELETE FROM fruit WHERE colour = 'red'");

echo "Deleted $cnt rows.";
?>