my $sthC = $dbh->prepare("insert TABLE (col1, col2, ...)
values(?, ?, ?)")
    or die "Couldn't prepare: $DBI::errstr";
$sthC->execute('value1', 'value2', ...)
    or die "Couldn't execute: $DBI::errstr";