i am running query like this

  my $SQL = "UPDATE kcrei_batch_job_history SET
                            rows_added = ?,
                            status = 'C',
                            stop_datetime = getdate(),
                            stop_tran_seq_nbr = ?,
                            elapsed_time_hh = datediff(hh, convert(dat
+etime,?), getdate()),
                            elapsed_time_mm = datediff(mi, convert(dat
+etime,?), getdate()),
                            elapsed_time_ss = datediff(ss, convert(dat
+etime,?), getdate())
                        WHERE
                            master_job_no = ? AND
                            master_job_sub_no = ?";
[download]

my $sth = $dbh->prepare( $SQL )
        or die "Couldn't prepare statement: " . $dbh->errstr;
 
    eval{
        $sth->execute($_[1],
        $hdr_tran_seq_nbr,
        $loader_start_time,
        $loader_start_time,
        $loader_start_time, 
        $master_job_no,
        $_[0]
        );
        $sth->finish();
    };

    if( $@ ) {
     
        outputErrorMessage( "$@" );
        outputErrorMessage( "$sth->{Statement}" );
    }
[download]

hi mje in this way i am running my query