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(datetime,?), getdate()),
                            elapsed_time_mm = datediff(mi, convert(datetime,?), getdate()),
                            elapsed_time_ss = datediff(ss, convert(datetime,?), getdate())
                        WHERE
                            master_job_no = ? AND
                            master_job_sub_no = ?";

##</code><code>##

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}" );
    }