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 = ?";
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}" );
}
hi mje in this way i am running my query